Forum Discussion

takui12's avatar
takui12
Helper II
10 months ago
Solved

Power BI Status Update Logic: Seeking Pro-License Solution for "Update In Progress" State

Hello everyone, I am facing a significant architectural challenge trying to provide users with semi-live feedback on a dataset refresh status within Power BI Service. The goal is to inform users wh...
Need Help
  • v-hashadapu's avatar
    v-hashadapu
    10 months ago

    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

v-priyankata's avatar
v-priyankata
Community Support
10 months ago

Hi takui12 

I wanted to check if you had the opportunity to review the information provided by user. Please feel free to contact us if you have any further questions.

 

takui12's avatar
takui12
Helper II
10 months ago

Hi there, thanks for tour replies but even if those solution may works, I don't have access to a sql server to write anything there, only reading, so...