Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Change data Source from File to Folder

Dear expert   I have one huge excel file in one power bi report, due to this report is covered sales from 2019 until current date, everyday when i run this report, it take very long time to uploade...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Please find the file I tried. Sales was CSV , the text was the folder.The file is attached after signatures

    cvs code in inside the comment /* */

v-robertq-msft's avatar
v-robertq-msft
Community Support
5 years ago

Hi, Anonymous 

Have amitchandak’s reply helped you to solve the problem?

To change the original data source to replace it with a new file or folder, there are two ways to in Power BI desktop:

  1. Go to Transform data-> data source setting, change the source of data:

 

  1. Go to the power query editor, advanced editor, replace the file path to change the data source manually:

 

Before updating your data source, you should first check if the column name and data type are the same as the columns in the original Excel file. If not, you will get an error.

Then you should update the reference of the next steps according to your actual situation.

 

Best Regards,

Community Support Team _Robert Qin

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