cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pchmurzynskivf
Frequent Visitor

Refreshing the source turns all Visuals blank

The dashboard works fine in desktop, but after a refresh it turns blank.
Right after upload:
working dash.jpg
And after a refresh:
not working dash.jpg

I've seen other topics with a simmilar question, but without a silution.

4 REPLIES 4
v-kalyj-msft
Community Support
Community Support

Hi @pchmurzynskivf ,

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:

 

vkalyjmsft_0-1655789853463.png

 

 

After refresh:

 

vkalyjmsft_1-1655789853460.png

 

 

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.

 

vkalyjmsft_2-1655789853348.png

 

 

Selected all (empty) visuals and copied them to a new TAB. By the way duplicate page does not work.

 

 

vkalyjmsft_3-1655789853462.png

 

Et voila.

 

vkalyjmsft_4-1655789853464.png

 

 

Okay so the data is still there. Copied all original report like this. Ending up with some extra tabs.

 

vkalyjmsft_5-1655789852916.png

 

 

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"

vkalyjmsft_6-1655789852924.png

 

 

Report "Planning v2"

 

 

vkalyjmsft_7-1655789853466.png

 

 

 

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.

ribisht17
Memorable Member
Memorable Member

 

@pchmurzynskivf 

 

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?

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors