Excel file to CSV file DataSource Change in power bi

[Anonymous]

I have using Excel data source file for my Dashboard creation from my Sharepoint site. Now i have to change the datasource from Excel to CSV. i tried to put CSV file in my site folder but when i try connect its shown error message. kindly help me in this.

[Anonymous · Accepted solution]

Hi @Anonymous 

I already konw your question.

If you want to change the data source, please try this:
The easiest way is that change through the Data source setting:

It is the only way of changing data sources through the Power BI report interface.

Open the Power BI desktop, and Click the File > Options and settings > Data source settings.

Choose Data sources in current file, and select your excel data source, and click change Source

Then re-public.

Or you can change the data source in power query, these links may help:

6 Ways to Change Data Source in Power BI - Power Tech Tips

Changing Data Source Location in Power Query • My Online Training Hub

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PijushRoy]

HI @Anonymous 

Please find the video for your reference - https://www.youtube.com/watch?v=vPV67RLGoOg

Please describe the error and share a screenshot of the error.