Forum Discussion
Helper ISharepoint CSV auto refresh does not work
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
Helper II 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.
Helper IIHI dan_hoff,
I don't know if this can help you to see why it's doesn't working for you, OneDrive is Cloud like SharePoint, but PBI doesn't consider SharePoint as a Cloud, or it's only for Cloud like OneDirve is, that schedule refresh is automaticaly set and refreshed, and not for SharePoint, for which you need to set Schedule Refresh.
I don't know why it's like that, but for me, yeah it's dumb / for the moment I don't know why it's like that, maybe sombody can explain us here :) /.
- dan_hoff
Thanks Lutece for also confirming all this. I can live with it, as long as I know. I wish MS was more clear. I spent a lot of time testing various scenarios.