Visuals are empty after refresh

[DUriah1977]

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 split second show data 

and then they are empty. There are no error messages and the datafields are all available and selected 

correctly for the visuals. The refresh status is completed. What could be the problem?

[v-juanli-msft]

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]

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.