Forum Discussion

dan_hoff's avatar
dan_hoff
Icon for Helper I rankHelper I
9 years ago
Solved

Sharepoint CSV auto refresh does not work

I have been using Power BI for about 6 months.  I recently migrated my data sources from onedrive to sharepoint.  XLXSd to CSV files.   The CSV data sources NEVER update automatically based on chan...
Reports
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    dan_hoff

     

    The public info should guide us to get data in Power BI Service directly as below. In this way, we do not need to schedule refreshes.

     

    If we follow the steps mentioned in this document to get data from the csv file stored in SharePoint with Power BI Desktop. We need to schedule refresh after we publish the report to Power BI Service.

     

    Best Regards,
    Herbert

dan_hoff's avatar
dan_hoff
Icon for Helper I rankHelper I
9 years ago

I have set up a couple of scheduled refreshes, and they work fine.

 

I would PREFER for the Power BI to 'see' the Sharepoint files have been updated - and auto refresh.  But I wcan live with the eight time as day refresh.

 

If anyone can know why the auto refresh does not work, please let me know.

 

Perhaps because the data sources were defined in Desktop, then published, it does not work the same as if the data sources were defined in the BI service.  I just do not know.