Forum Discussion
Power BI Status Update Logic: Seeking Pro-License Solution for "Update In Progress" State
Hi takui12 ,
Thank you for pointing out the issue. I incorrectly mentioned that a SharePoint Online List could be used in DirectQuery mode. That was an honest oversight because while Power BI supports composite models and DirectQuery over many sources (like SQL, Dataverse and Fabric data warehouses), SharePoint Lists are Import-only. When you connect to them, Power BI always loads the data once at refresh time, with no live query capability.
Given that limitation and with only read access to SQL and no Premium capacity, there isn’t a straightforward way to show semi-live refresh status inside your Power BI report using Pro licensing alone. The best alternatives are to use a Power BI Push/Streaming dataset for status updates, though this has limitations and will be deprecated or to rely on external notification methods like Teams or email alerts from Power Automate. Unfortunately, a fully integrated, instantly updating status inside the report isn’t feasible with current Power BI Pro features and your available data sources.
Create a report on a SharePoint List in Power BI Desktop - Power BI | Microsoft Learn
Use composite models in Power BI Desktop - Power BI | Microsoft Learn
Real-time streaming in Power BI - Power BI | Microsoft Learn
Hi takui12 , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.
I've tried but when i select the SharePoint list in pbi, it doesn't give me any direct query option...
Hi takui12 ,
Thank you for pointing out the issue. I incorrectly mentioned that a SharePoint Online List could be used in DirectQuery mode. That was an honest oversight because while Power BI supports composite models and DirectQuery over many sources (like SQL, Dataverse and Fabric data warehouses), SharePoint Lists are Import-only. When you connect to them, Power BI always loads the data once at refresh time, with no live query capability.
Given that limitation and with only read access to SQL and no Premium capacity, there isn’t a straightforward way to show semi-live refresh status inside your Power BI report using Pro licensing alone. The best alternatives are to use a Power BI Push/Streaming dataset for status updates, though this has limitations and will be deprecated or to rely on external notification methods like Teams or email alerts from Power Automate. Unfortunately, a fully integrated, instantly updating status inside the report isn’t feasible with current Power BI Pro features and your available data sources.
Create a report on a SharePoint List in Power BI Desktop - Power BI | Microsoft Learn
Use composite models in Power BI Desktop - Power BI | Microsoft Learn
Real-time streaming in Power BI - Power BI | Microsoft Learn