cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NadaBen
Helper I
Helper I

change path to data

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 

 

 

 

1 ACCEPTED SOLUTION
Phil_Seamark
Microsoft
Microsoft

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

 

Source Editor.jpg


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

3 REPLIES 3
Phil_Seamark
Microsoft
Microsoft

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

 

Source Editor.jpg


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

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.2017-05-29_15h21_52.png

 

Thanks

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'....

 

KBee_0-1603186630513.png

 

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

 

Many thanks

Katie

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.