Successful refresh but no data available for the report

[breiney]

I have a single report refresh in my Power BI ecosystem (Premium Capacity) that appears to complete successfully, but no data is available in the report. It does have an inefficient database query which we will handle separately, but the business is being presented with a blank report while no one is notified of a failure. Has anyone experienced this? Know how to avoid it?

You can see that it shows 2 timeouts but then a supposedly successful attempt in line 3. The report is completely blank though.

[breiney]

Thanks to all who responded. Unfortunately, now my refresh is just failing every day so I can recreate the blank page issue. We will work on the query performance instead. If it happens again, I'll try the SQL Profiler suggestion. We know the query has an issue, but were stumped by the Power BI service saying that the refresh was complete, yet providing an empty report. If it happens again, we'll open a ticket with Microsoft.

[suparnababu8]

Hi @breiney 

The same issue I faced yesterday. Even after sucessful refresh, I'm unable to see proper data in my Line and Clusterd bar chart.

But, after browser refresh, I got the proper data in my report.

Suggestion: After sucessful refresh of dataset, you have to do a browse/tab refresh. I excpeted it's a bug in Power BI services. But, I'm not sure.

Thanks!

[breiney]

Thanks, I had tried refreshing my browser page and the Power BI report visuals with no luck. All visuals were still blank even though the refresh was marked as completed.

[lbendlin]

Visualise your Power BI Refresh - Phil Seamark on DAX

[SaiTejaTalasila]

Hi @breiney ,

Check with SQL profiler whether the same issue occurs or not.

Thanks,

Sai Teja 

[breiney]

Sorry, I'm not super experienced with external tools. How do you use SQL Profiler on a report refresh in the Power BI service?

[SaiTejaTalasila]

Hi @breiney ,

If your reports are hosted on premium capacity workspace then you can use XMLA analysis services endpoint and you can refresh your tables in your semantic model from SSMS.

You can publish a copy of your report on a different workspace and see whether the same issue occurs or not.

Thanks,

Sai Teja 

[breiney]

This report runs for a range of dates and no changes to the report or query or default parameters. If the query succeeds the first time data is available in the report, if fails and then succeeds in the same refresh, the report is blank, no data. I've tried refreshing the page, the visuals, setting parameters to default, changing them. It's just blank. I'm stumped.

[lbendlin]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

[lbendlin]

Examine your query for any filters that can cause this - remember the Power BI Service runs on UTC, so "Today"  means something different on the service than it means for you.