Forum Discussion
PowerBI report data goes blank when refreshing on PBI Service but no error displayed
Hello Anonymous ,
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!
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
Service:
How to apply sensitivity labels in Power BI - Power BI | Microsoft Learn
2.Secondly, whether RLS is set for PBIX.
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?
2.Second, if your refresh settings OneDrive refresh are on, check that the current switch is turned on in the semantic model settings:
3.Contact your administrator to check if it is enabled in the admin portal:
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 Anonymous ,
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!