Forum Discussion

NadaBen's avatar
NadaBen
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.     Than...
Need Help
  • Phil_Seamark's avatar
    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

     

Phil_Seamark's avatar
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's avatar
    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's avatar
      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