Power BI and D365 Business Central: Connecting Your Data

[@tonyjones4980]

Really helpful , I’m still learning.. keep it up

[@dominikreim7723]

This Session is very helpful! Thank you!

[@indranijayakody3381]

Very good video to learn. Thank you

[@justmejustme4444]

I found this video really helpful thank you. I need to report on Supplier invoices paid in a period - anyone know what web service links payments to invoices?

[@krishnachauhan6439]

hi, i have tried to connect business central Onpremise wih powerbi using same process as you shown in this vedio, but this is showing the Remote connection not valid, error. is there any other way to connect the same?

[@brad7648]

When building out Power Bi reports for Business Central On-Prem I would always connect directly to the SQL Database and pull in the tables needed using SQL query. That might be easier for you.

[@ankitkishore77]

thanks a ton Team Stoneridge.

[@DanecoService]

Hi Igor, thanks for the informative video. I am consulting customers for BC Cloud. In PowerBI there is directly a connector for BC Cloud. But this always takes my own login and goes to my own tenant. How can I connect to another tenant with a specarate login?

[@sinnersavedbygracethrufait8933]

Great, thank you!

[@pthapa55]

Awesome video, thank you. I do have a question though on how to query the data from business central. For example we can use sql query to join and bring up data in power bi when the data house in sql server on premise. In the case of Business central, how can we do that query part? Is it even possible like in sql server we are able to do? Practically query helps for better performance in power bi so not sure how that can be achieved when the data resides in business central. If you could please do a video on that, it would help a lot of viewers. Appreciate the efforts.

[@DynamicsCon]

BC only has API access, i believe. i think you'd need to export the data to data lake / synapse or somewhere using azure data factory so that you could report on it via TSQL.

[@pthapa55]

@@DynamicsCon Thanks

[@manjunathd7770]

Hi Igor.. It was really informative. One question - if there is any update in the customer ledger entry or any addition of items due to new PO. Will the changes reflect directly on the BI ? Can you please explain this ?