Power BI users desire to see the real-time data; in sync with their data source, on their dashboard. Since the exact source refresh completion time cannot be assumed, instant updating of data isn’t possible by scheduling the data refresh in the Power BI service.
Among the three Power BI Connectors, choose the Direct Query mode to create the dataset and witness the real-time data. But the limitations of using the Direct Query mode may restrict the user to achieve his desire.
In this case, creating a PowerShell script to invoke the Power BI dataset refresh using Rest API, and adding the execution of this PowerShell script as a step or as a process in the source refresh job (SQL Job, Schedulers, etc.) could help.
Technovert offers a set of Business intelligence consulting services including PowerBI, Data Science, Data Management, and Modernization. Get in touch with us to accelerate your digital transformation journey.
|