Excel file to CSV file DataSource Change in power bi

Question

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 Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
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 &gt; Options and settings &gt; 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
&nbsp;
Best Regards
Zhengdong XuIf this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.
&nbsp;

Forum Discussion

Excel file to CSV file DataSource Change in power bi

2 Replies

Related content

Datasource column name change

Datasource column name changed

Excel DataSource

Change in Datasource Problem

Change gateway datasource