Forum Discussion

DUriah1977's avatar
DUriah1977
Frequent Visitor
8 years ago

Visuals are empty after refresh

Hello, I use a SharePoint Online list as a datasource. When I publish to Service all data is shown in the visuals in the report and dashboard. After a manual or planned refresh the visuals for a spl...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi DUriah1977

Could you check these on your site so we could focus effectively about this issue?

Do you apply the unpivot function or use Booleans in filter on the report or visual? It is tested to show up empty after refresh from service.

Besides, if it is not in that case, you could :

update the Power BI desktop version to the latest version: 2.57.5068.501

republish the report to see if issue persists

How about the result when you try another browser to view report

does this issue occur for any other datapoints in the same report?

 

 

Best Regards

Maggie

DUriah1977's avatar
DUriah1977
Frequent Visitor
8 years ago

Hi Maggie,

 

Thanks for the reply. I don’t use booleans in the filters on the reports or visuals, but I do filter on certain states of an issue. Unfortunately I can’t upgrade my version of Power BI Desktop because in our organisational environment we are several months behind on versions. I can use an offline Desktop version but I need all my stuff to stay compatible with the rest of the organisation. 

 

Totday I have discovered something strange in my report in PBI Service. I use a datefield from a date table in a slicer that’s set in a relative range. When I delete this slicer from my report all visuals show data again. The datefield that is used in the slicer is taken from a date table which I have created with a query. The datefield has a relationship with a timestamp datefield in my SharePoint list. The timestamps that were displayed in PBI at first had a mismatch with the timestamps in the SharePoint list, but I used the following sollution:

 

In the query editor:

 

1) I have changed the format of the timestamp column to date/time/zone

2) I have changed the Locale to Dutch for date/time/zone

3) I have opened advanced editor and deleted “zone” from the code. Underneath the part I deleted is bold and underlined:

 

{{"Timestamp", type datetimezone}}, "nl-NL") → {{"Timestamp", type datetime}}, "nl-NL")

 

In PBI Desktop this fix works all fine, but could this mess up the dates on PBI Service after refreshing?

I hope not because I have not found another way to get the dates/timestamps right.

 

Sorry for the large text, but I had to explain my actions.

 

Thank you.