Forum Discussion

Helper I

9 years ago

Solved

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

Phil_Seamark
9 years ago
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

3 Replies

Phil_Seamark
Microsoft Employee
9 years ago
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
  Resolver III
  9 years ago
  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
    Regular Visitor
    5 years ago
    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