Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 publis...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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!

foucaultf's avatar
foucaultf
Frequent Visitor
4 years ago

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