Forum Discussion
PBI Service Dataset refresh changes the data in the visualizations
Hi community, my first post here, so please go easy on me 😊
Background:
I have made a report in power bi desktop, which includes three data-sources from three different folders in sharepoint.
The sharepoint folders have all multiple files with data for different time ranges. 2 of the folders have one .csv file for each day, with the date as its filename with a post-fix. The 3rd folder have .xml files with data, again with date in filename. I use power query with three queris, one for each folder, to concatenate the datasets. Here's an example of a visualization from pbi desktop:
The problem:
When I make visualizations etc in power bi desktop, everything works just fine. And when I refresh the dataset/visualizations, it updates with the newest available data. When I publish the report with my power bi pro account, it works just fine. However, when I do an manual or automatic dataset update in power bi service, the data/visualizations change, and show wrong data. Example of a visualization after pbi service data update (this should look identical to the graph above):
Steps I've taken:
- I've tried to delete dataset and publish again
- Looked over all measures/dax expressions
- In power query, split the query into multiple queries to (at least try to) bypass query folding
- Change settings for language and region (it's timeseries data, so could be it read the dates or timestamps wrong)
Has anyone seen anything like this before?
Hi, Anonymous
According to your description, the data is correct when you first publish to Power BI Desktop and Power BI Service, but after manual refresh and scheduled refresh in Power BI Service the data has changed wrongly.
Since some functions of Desktop get the local date/time, and Serivce gets the date/time of the server, you can try to check the following points:
(1) Check if the measure value used in the visual with the wrong data uses a DAX function such as TODAY() or NOW() that causes the data to change after the refresh.
(2) In the Power Query Editor, check whether there is a function about the acquisition time, which causes the acquired data to change. You can refer to the following document: https://radacad.com/solving-dax-time-zone-issue-in-power-bi
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
1 Reply
Hi, Anonymous
According to your description, the data is correct when you first publish to Power BI Desktop and Power BI Service, but after manual refresh and scheduled refresh in Power BI Service the data has changed wrongly.
Since some functions of Desktop get the local date/time, and Serivce gets the date/time of the server, you can try to check the following points:
(1) Check if the measure value used in the visual with the wrong data uses a DAX function such as TODAY() or NOW() that causes the data to change after the refresh.
(2) In the Power Query Editor, check whether there is a function about the acquisition time, which causes the acquired data to change. You can refer to the following document: https://radacad.com/solving-dax-time-zone-issue-in-power-bi
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly