Solved: Updating data sources with weekly files

ukare1996 · ‎11-14-2022

Hi All,

I have some weekly files in sharepoint (separate files) - I have created a Power BI report - my question is, as the files are imported weekly in sharepoint, how do I automate this to ensure that the current data in the report stays the same and the new data is added on?

Many thanks,

Recho

Anonymous · ‎11-14-2022

Hi @ukare1996 ,

Since you connect to a cloud data source(the file in Sharepoint), the data in the report will sync with those changes too(usually within about an hour), when the data source have any update. You can find more details in the following official documentation.

Refresh a dataset from a cloud Power BI Desktop file

Best Regards

View solution in original post

Anonymous · ‎11-14-2022

Hi @ukare1996 ,

Since you connect to a cloud data source(the file in Sharepoint), the data in the report will sync with those changes too(usually within about an hour), when the data source have any update. You can find more details in the following official documentation.