Hi,
Choosing Business Central as a Data Source in PowerBI offers plenty of tables, but not all of them.
Is there a way to load more Business Central tables than offered into PowerBI? Exporting a table from BC to Excel and then loading that into PowerBI is not an option, because it is no live data.
More precisely I can not load the following table into PowerBI:
I'm looking forward to your answers!
Alex
Adding new pages via the Reporting Data Setup wizard is a solution, however not all pages are suited for Power BI and the might not contain the fields you need.
Better is to develop new API Queries with aggregated data (method=Sum, group-by) with exactly the tables/columns you need.
Hi.
Not all tables are available in the standard Power BI connector.
You need to expose the tables you need via API using the Web Service page in Business Central.
Use the Create Data Set action and you will be guided to a setup where you can choose the table and the fields to expose.
Once done, the table data will be visible in Power BI.
Hi Amit,
I have Dyn365 BC Premium and Power BI Pro License
Hi,
Pls check License of BC D365 and Power BI.
Regards
Amit Sharma
https://www.linkedin.com/in/amit-sharma-94542440/
Press Yes if info is useful.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,524 Super User 2024 Season 2
Martin Dráb 228,493 Most Valuable Professional
nmaenpaa 101,148