Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
jasskskw21
Regular Visitor

PowerBI report data goes blank when refreshing on PBI Service but no error displayed

jasskskw21_2-1722536048550.png

jasskskw21_4-1722536484595.png

 

 

Hello,

 

I created my first PowerBI report and I'm having issues with scheduled refresh (or any refresh) after publishing it on PowerBI Service. I updated the app as well and I have the necessary user rights to publish.

 

The reports works perfectly on desktop and refreshing works there. I uploaded to a company Sharepoint folder and from there published to Service. IT set up the gateways and the credentials were entered. There are two on-premise gateways and one cloud connection, though one appears in red, we have other reports with the same setup that work correctly. Scheduled refresh was set up as well with no errors.

 

Nonetheless, after refreshing the semantic model on Service, the report goes blank and instead of data, it shows "--"  as shown on the picture, and there is no error notification. No one in my organization has discovered the issue.

Any hint as to what might be the issue would be greatly appreciated as I look forward to completing my first report and bringing needed visibility within the organization.

1 ACCEPTED SOLUTION

Hello @v-linyulu-msft ,

 

The problem was the date filters.

 

They worked well on Desktop but once on Service, they would make the report go blank.

 

I removed data with blank dates and now changed the data types using locale. Now it works and refreshes.

 

Thanks for the proposed solutions!

View solution in original post

4 REPLIES 4
v-linyulu-msft
Community Support
Community Support

Hi,@jasskskw21 

Regarding the issue you raised, my solution is as follows:

1.You can check if the sensitivity label of your PBIX file is hidden from the data.
Desktop
 

vlinyulumsft_0-1722564436151.png

 

Service:

vlinyulumsft_1-1722564436152.png
How to apply sensitivity labels in Power BI - Power BI | Microsoft Learn

2.Secondly, whether RLS is set for PBIX. 

vlinyulumsft_2-1722564474703.png

Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn
 

It is important to note that it will take some time for the above settings to take effect for the entire organization after they are modified.


Of course, if you have any new ideas, you are welcome to contact us.
 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello Leroy,

 

Thank you for your response and proposed solution.

 

As the report has no Sensitivity labels (Sensitivity is greyed out) and the RSL is set to none as your screenshot shows, the issue remains unfortunately.

I get the feeling a setting must be enabled or disabled as the report behaves perfectly on desktop version, even when refreshed and same after being published on Service (until the semantic model is refreshed there).

 

Thanks for the response.

Hi,@jasskskw21 

Regarding the issue you raised, my solution is as follows:

1.First, have you tried enabling only the cloud gateway or on-premises gateway to see if it's an on-premises gateway connection or a refresh blank caused by the on-premises gateway connection?

vlinyulumsft_0-1722839469715.png

2.Second, if your refresh settings OneDrive refresh are on, check that the current switch is turned on in the semantic model settings:
 

vlinyulumsft_1-1722839469716.png

3.Contact your administrator to check if it is enabled in the admin portal:

vlinyulumsft_3-1722839553603.png

 

 

Refresh a semantic model from OneDrive or SharePoint Online - Power BI | Microsoft Learn

4.Finally try updating the on-premises gateway and republishing from SharePoint.


Of course, if you have any new ideas, you are welcome to contact us.
 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello @v-linyulu-msft ,

 

The problem was the date filters.

 

They worked well on Desktop but once on Service, they would make the report go blank.

 

I removed data with blank dates and now changed the data types using locale. Now it works and refreshes.

 

Thanks for the proposed solutions!

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors