DirectQuery with Dynamics 365 Business Central

[pakovic]

Is there any way to use DirectQuery for Dynamics 365 Business Central?
When using the Dynamics 365 Business Central powerbi connector, I do not have the option to use DirectQuery.

If I choose the "Dataverse" connector that does allow DirectQuery, I do not see the api, nor the tables, nor the Dynamics 365 Business Central Web Services. is there any way to use Directquery with Dynamics 365 Business Central?

[SabuSentry]

There are special services that will help you integrate Jotform and Microsoft Dynamics 365. For example, microsoft dynamics 365 business central. First you need to register. Choose what data to transfer from Jotform to Microsoft Dynamics 365. Turn on auto-update. Now the data will be automatically transferred from Jotform to Microsoft Dynamics 365. There is no need to pay anything for the integration itself, and all the functionality is fully available on all tariffs. You pay only for the amount of data that is actually transferred from one of your systems to another through this service. If you have a small amount of data per month, you can safely use the free plan or upgrade to a paid one, if necessary.

[Anonymous · Accepted solution]

Hi @pakovic 

So far, Power BI could not connect to Dynamics 365 Business Central with DirectQuery or Live connection.

For more details, you can read related document: Power BI data sources - Power BI | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pakovic]

ok, thanks for your answer.
However, is it possible to directly access the database tables in azure from dynamics business central?

[Anonymous]

Hi @pakovic ,

You could deploy a Business Central database to Microsoft Azure SQL Database.

For more details, you can read related document: Running a Business Central Database to Azure SQL Database - Business Central | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.