Forum Discussion
Business Central 365 Cloud (DirectQuery)
Hi Monolithe85
Maybe you can try these steps:
Use the Power BI REST API to push data into a Power BI dataset. This method allows you to create real-time dashboards that update as new data arrives. Or set up streaming dataflows to process and visualize data in real-time. This method is suitable for scenarios where you need to display transient data.
Real-time streaming in Power BI - Power BI | Microsoft Learn
Synchronize your Business Central data with an Azure Data Lake. From there, use Azure Synapse Analytics to process and load the data into Power BI. This setup can provide near real-time data updates.
It's worth noting that A Fabric license is required to use this method.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Thank you so much for this, I will give it a go.
Hi Monolithe85
Maybe you can try these steps:
Use the Power BI REST API to push data into a Power BI dataset. This method allows you to create real-time dashboards that update as new data arrives. Or set up streaming dataflows to process and visualize data in real-time. This method is suitable for scenarios where you need to display transient data.
Real-time streaming in Power BI - Power BI | Microsoft Learn
Synchronize your Business Central data with an Azure Data Lake. From there, use Azure Synapse Analytics to process and load the data into Power BI. This setup can provide near real-time data updates.
It's worth noting that A Fabric license is required to use this method.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much for this, I will give it a go.