Hello all,
I want to ask : What permission should i have to create a sales report in PBI where i can pull data directly from Business Central?ù
How do we display these built PBI dashboards in BC ?
Thank you in advance.
Hello all,
I want to ask : What permission should i have to create a sales report in PBI where i can pull data directly from Business Central?ù
How do we display these built PBI dashboards in BC ?
Thank you in advance.
It depends on the user/account you use to refresh the data. Power BI uses web services, via the API, so the same BC permissions apply.
Once you create the PBI report, you can publish it to your PBI service. Then you can simply embedd the report in BC.
Here's a good overview:
Microsoft Dynamics 365: How to create and embed a Power BI report into Dynamics 365 Business Central:
Please check these links
docs.microsoft.com/.../across-working-with-powerbi
docs.microsoft.com/.../admin-powerbi
Regarding Permission, it depends a lot based on the type of data you are displaying, if it is open sales you need access to the sales header, sales line table but you are looking for statistics you need to have access to Item Ledger Entries....
YUN ZHU
628
Super User 2025 Season 1
Mansi Soni
495
Sagar Dangar, MCP
395