change path to data

[NadaBen]

Hello,

i'm connected to an excel table, i want to change the location of my file. How can i do to change the path in PowerBI, so that i can get  the right connexion to the right file.

Thanks 

[Phil_Seamark · Accepted solution]

Hi @NadaBen

In the Query Editor you can click on the Source cog in the Applied Steps to bring up a window where you can probably change this

[gopichilla]

Hi @NadaBen

This is the second way to change file path.

Go to file ->choose options and settings->go to data sources setting ->chabge source of your file.

Thanks

[KBee]

Hi, I'm hoping soneone can help me on a simular matter to the above.

I have mistakenly built a BI Report with my dataset as an 'exel file' however the file is saved in my sharepoint therefore I need to change the data set type to 'web' (I have the path to this its only the type I need help with).

When I follow the two options above to change the data set it only give me a few options to 'Open file as'....

Does anyone know if any of these options works like 'web' with a sharepoint file location?

Many thanks

Katie