Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
The dashboard works fine in desktop, but after a refresh it turns blank.
Right after upload:
And after a refresh:
I've seen other topics with a simmilar question, but without a silution.
Hi @Anonymous ,
Please check if your filters are set to boolean values.
For your convenience, I quoted the solution of @Wouter in this issue.
Situation.
Created a nice report on a sharepoint list. Showed it to my client on the desktop and even the published version. General reaction ..==> "giveme giveme". Okay, give me 5 minutes and you are good to go...but then.. set up scheduled refresh.
Before refresh:
After refresh:
Tried a zillion things (removing backgrounds, all kinds of powerquery stuff, changing filters, sources, downloading PBIX refresh locally, etc..)
Finally edited the report in de powerbi services.
Selected all (empty) visuals and copied them to a new TAB. By the way duplicate page does not work.
Et voila.
Okay so the data is still there. Copied all original report like this. Ending up with some extra tabs.
Let's refresh again: After changing some date in the source so I'm sure the data is really refreshed.
Still the original reports show up empty. The new (v2) version all showed refreshed data.
Okay let's download the report and see what powerbi desktop will do/show/discover/debug..??
Compered report "planning" and "planning v2" (the version created online).
Quickly discovered difference in Page level filter:
Report "Planning"
Report "Planning v2"
In retrospective: DO NOT USE BOOLEANS IN FILTERS.
Change it to text in powerquery, change you're filter setting, and you are good to go!!.
Hope it helps!
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for that, but its not it. there are 4 slicers: 3 text and 1 date. There are no page, visual or report level filters.
@Anonymous
Please check my post here
Solved: Report Goes Blank After Scheduled Refresh - Power ... - Microsoft Power BI Community
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users
Thanks. The link you shared is a post with another link which says:
"the dataset for that app report was in another app the user didnt have read\compile permits, added the needed permit on source dataset and it started working. "
But that is not the issue here. The source is the same as for 6 other reports which are refreshing and showing fine. Any more ideas?
User | Count |
---|---|
64 | |
27 | |
25 | |
17 | |
11 |