Forum Discussion
Business Central 365 Cloud (DirectQuery)
Hi,
So I’ve created a report that shows all current sales orders and divides them into orders by date, next working day orders, and total orders, where it then calculates how many hours are expected to be spent on the current and next working day.
But how do I get it to update in real time when it’s connected to Cloud Business Central?
I know it doesn’t support DirectQuery (which I don’t understand why isn’t a feature yet?).
I tried using Power Automate to refresh every 5 minutes, but I’m limited to a maximum of 8 refreshes a day with the pro license.
Another option I’ve read about is replicate the data from BC over to an Azure SQL database, but I think that’s a bit overkill since we’re only talking about a maximum of 1.500 rows.
Our needs are fine with the max 8 refreshes a day for the other reports I’ve made, but I’d like something more real-time with this report so the warehouse can keep up and see.
Any suggestions?
Thank you guys!
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.
2 Replies
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.