You’re offline. This is a read only version of the page.
5
Hi All,
I have asked this question on the PBI Forum, but perhaps it will be better to ask here. I have the case where the company has Business Central as their ERP system.
Currently, every user that connects to the Business Central tenant via Power BI is able to see, extract and transform ALL the tables + Columns in Business Central.
We require the need to have security measures in place whereby certain users that will be creating reports in Power BI will have separate restrictions on the data they can extract, based on their role. As it stands now, everyone in the organisation that has a Power BI Pro licence is able to see any data currently existing in Business central.
I am struggling to find a clear document outlining the options here.
1) Is there a way to restrict the sensitive tables + columns per user? Is this done in Power BI or in Business Central?
2) If the above is not possible, what are the alternatives to allow certain users in the company the ability to create reports from Business central without the possibility of leaking sensitive information to users that will not be required to create reports but, will have Power BI licences and Restricted access to Business Central?
Please let me know if anything is unclear, and thank you in advance for any experiences or help on the matter.
Kind Regards,
Max
Roles defined in your Business Central user (ap AD app if you're using OAth2) determines what entities you can see. Than I think you need to set permissions on meaures on your Power BI report.
#1
Sohail Ahmed
2,737
Super User 2025 Season 2
#2
Sumit Singh
2,577
#3
Jeffrey Bulanadi
2,251
Share
Report
All responses (
Answers (
