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 /* */

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Would be a bit difficult. Create the folder source in anew source. Get the code from

Home Tab -> Transform Data ->Transform Data -> Right click on Table -> Open Advance Editor and take the top part of the code and place it in place of the old connection code.

 

keep back up of file

 

refer this video - https://www.youtube.com/watch?v=59PUFuuCrbY

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I follow your instruction but it won't allow me to do it. The pop out screen as below:

 

Please advise.

Thank you

 

Maggie

  • amitchandak's avatar
    amitchandak
    Super User
    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 /* */