How to change report data source from local sample to sharepoint csv

Question

Being new to Power BI, I used a subset of data in csv format to create my report.&nbsp; Now that the report is complete, the data source needs to be a SharePoint csv file.&nbsp; How do I do this?&nbsp; Do I change the data source prior to publishing? Are step-by-step instructions / examples available?

kentyler · Answer

I believe this blog post is a "step by step" example.https://visualbi.com/blogs/microsoft/powerbi/implementing-source-data-location-change-existing-power-bi-reports/

tahreem24 · Answer

You can refer below step to change the data source:
Go to query editor --> go to select query step at right panel--> select source -->so it will open formula bar and under that change the file path to new file path.

Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.

tahreem24 · Answer

Or you can refer below video of 4 mins to get your need.https://youtu.be/mqoV-CRegp8Don't forget to give thumbs up 👍and accept this as a solution if this helps you.

anonymous · Answer

Thanks for the link.&nbsp; This looks simple, but browsing does not show SharePoint as an option.&nbsp; How do I do that?&nbsp; Also, if the filename is different going to the production dataset, will created measures automatically be converted?

v-alq-msft · Answer

Hi,&nbsp;Anonymous&nbsp;&nbsp;Importing files from OneDrive or SharePoint Online into the Power BI service is a great way to make sure your work in Power BI Desktop stays in sync with the Power BI service. When you connect to a .csv file on OneDrive or SharePoint Online, a dataset is created in Power BI. Data from the .csv file is then imported into the dataset in Power BI. Power BI then automatically connects to the file and refreshes any changes with the dataset in Power BI. If you edit the .csv file in OneDrive, or SharePoint Online, once you save, those changes will appear in Power BI, usually within about an hour. Any visualizations in Power BI based on the dataset are automatically updated too.&nbsp;For further information, you may refer to the following links.https://docs.microsoft.com/en-us/power-bi/refresh-desktop-file-onedrivehttps://docs.microsoft.com/en-us/power-bi/refresh-csv-file-onedrive&nbsp;Best RegardsAllan&nbsp;If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

How to change report data source from local sample to sharepoint csv

8 Replies

Related content

Sharepoint online and Reporting server

Sharepoint list mirroring

SharePoint Access

Extract Data from sharepoint

Deployment pipeline not detecting report changes