cancel
Showing results for 
Search instead for 
Did you mean: 

Visualization BLANK after refreshing page in Power BI service

I have several visualizations that work in desktop mode but appear blank after publishing.  These worked at one point in time but now they no longer work.  Sometimes you can see the data for a split second and then it disappears.  Or, if I close my browser and re-open the report on the web, the data shows momentarily but disappears if the page refreshes.  Everything else in the report publishes as expected.  I've tried re-creating these particular visuals multiple times but always get the same result.  This is occuring with both a line graph and KPI visual (though these work with other measures).   

 

 

 

Status: Needs Info
Comments
Frequent Visitor

I had a very similar problem today, turns out there were two strange things happening.

 

Firstly the unpivot function was throwing errors due to sharepoint record type fields that were in the table being unpivoted. I removed any record fields prior to unpivoting and that resolved any query errors. Worth noting that this didn't seem to be an issue in the previous version of powerbi desktop but the error has  after updating my desktop powerbi client today and was present online.

 

Secondly, and possibly more likely the case for those issues above, it seems like the online version of Power BI is treating/displaying boolean values differently to the desktop client. Desktop client shows booleans as FALSE and TRUE but online it's displaying them as 0 and 1. So any reports that were filtering on boolean sharepoint fields weren't showing any data in the online client but were fine in the desktop client of Power BI. I'm not sure whether I just missed this or whether it also is a result of the latest PowerBI release. My workaround was to advanced filter for TRUE or 1 and FALSE or 0 when using boolean fields.

 

Update: strangely the online client seems to fluctuate between showing 0 and showing FALSE in any table visuals showing boolean values. So I cannot be sure whether it's a data issue or a display issue. In either case the workaround seems to have fixed it but we'll see if it stops showing data again in a few days time.

Regular Visitor

Howdy you unfortunate reader,

 

If you are are reading this you probably spent some time trying to solve your issue.

 

Hope I can Help.

 

SPOILER: CHECK IF YOUR FILTERS ARE SET TO BOOLEAN VALUES.

 

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:

 

1.png

 

After refresh:

 

2.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.

 

3.png

 

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

 

 

4.png

Et voila.

 

5.png

 

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

 

6.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"

7.png

 

Report "Planning v2"

 

 8.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!!.

 

Have a very nice day and keep on smiling 😊.

 

KR Wouter Kessener 

Frequent Visitor

@Wouter you are the best! 

 

I was looking for this answer for two weeks! 

 

Thank you!!!!

Stavros