Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I'm using the Log Analytics integration with my Power BI workspaces to monitor model refreshes. I'm also using the report templates available in Git. I'm seeing an intermittent issue where it takes my model hours to refresh when the typical refresh time is about 20 minutes. Using the reports, I have identified a pattern in which there ExecuteSQL (OperationDetail) takes a few minutes but is then followed by a very long ReadData - sometimes hours.
What I'm trying to determine is, what is "ReadData" and where is it happening? This particular table is being refreshed via a Power BI Gateway so I want to know if ReadData spans the Microsoft service/network, internet, and my on-prem network or if this operation is confined to a subset of those. Is it a Microsoft issue, an internal network issue, or an issue with connectivity between the two.
Any thoughts??
Have you considered using Phil Seamark's approach to real time refresh monitoring?
Thanks. I came across it but I don't need that at this point. I have identified that the issue is with the ReadData operation. Now I just need to understand what that is. Seeing ReadData in real-time wouldn't help me there.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 58 | |
| 56 | |
| 35 | |
| 18 | |
| 14 |