I always use webservice to connect Business Central by PowerBI.

But recently I have a question: Is it possible to use DirectQuery for Dynamics 365 Business Central?
After my researching, I found that so far PowerBI could not connect Business Central with DirectQuery or LiveConnection

For more details, you can read the related documents
Re: DirectQuery with Dynamics 365 Business Central
Hi So far, Power BI could not connect to Dynamics 365 Business Central with DirectQuery or Live connection. For more d...
If you want to directly access the database tables in azure from dynamics business central, you will deploy a Business Central database to Microsoft Azure SQL Database.
For more detalis, you can read the following document.

Running a Business Central Database to Azure SQL Database - Business Central
Learn how to deploy a Business Central database to Azure SQL Database
I hope it will help you.


コメント