Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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 Employee
Microsoft Employee

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 Employee
Microsoft Employee

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.