Forum Discussion
Need Help: Data Changes after posting Online (from desktop)
Reaching out for support despite similiar threads posted with no solution.
CSV source files are hosted on Onedrive where Desktop will pull and aggregate through 8/2/2022. File is saved and published online.
I go into the portal and can see the data through 8/2/2022. However, 5-15 minutes later, the data will appear Blank as the latest time period is through 7/29/2022.
The csv files are identical in formats and less 25 mbs each. I dont understand why the data will cut the date back and restate on its own. I havent triggered a refresh. Other things I tried was updating my PowerBI desktop and Gateway. Deleting the entire dataset and reposting. Revisiting all the date filters to ensure no duplications.
A little help is appreciated.
Mel
Discovered the reason behind this. It was odd to see PowerBI showing all the data within period on desktop and not all in the virtual machine which is what publishing was doing.
The solution was adding another step in PowerQuery to recharacterize the column in Date format (again). That seemed to solve the missing dates. Onedrive was not the issue.
Thanks for the support!
3 Replies
- lbendlin
Super User
Chek with the other users of the OneDrive if they have any processes or flows running that react to files being added.
Hi Anonymous ,
Although you didn't trigger the refresh, OneDrive refresh synchronizes datasets and reports with their source files. By default, Power BI checks about every hour if a dataset connected to a file on OneDrive or SharePoint Online requires synchronization.
So make sure the csv file on onedrive has not been modified by you or others. For more information, you can refer to: Data refresh in Power BI - Power BI | Microsoft Docs
Alternatively, you can set the data source to local data to check if the data still appears blank.
Best Regards
Discovered the reason behind this. It was odd to see PowerBI showing all the data within period on desktop and not all in the virtual machine which is what publishing was doing.
The solution was adding another step in PowerQuery to recharacterize the column in Date format (again). That seemed to solve the missing dates. Onedrive was not the issue.
Thanks for the support!
