Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

How to change excel data source in Existing Power bi report?

Hello,
I am new to Power BI and I am not able to change data source in my PBI report.

Can you please help me with this?

  • Anonymous  Hey,
    You can update your data source from your Power bi desktop. Kindly follow below step.


    Select Transform data drop 
    data source setting 
    select data file and change data source 
    update your excel reference.

     

     

    Thanks
    Harish.

     

5 Replies

  • Anonymous  Hey,
    You can update your data source from your Power bi desktop. Kindly follow below step.


    Select Transform data drop 
    data source setting 
    select data file and change data source 
    update your excel reference.

     

     

    Thanks
    Harish.

     

  • Hi Anonymous ,

     

    For that you need to go to the data source settings:

     

    Then select the file and change source

     

  • Hi Anonymous , 
    You can change the data source by going into transform data option :
    Once the Power query window is open, click on your excel table and from Applied steps ---> click on source --->
    Now you can change the path for your excel data source.

    Thanks,

    Ankita

  • Hi Anonymous 

    Please follow the steps

    1. Go to file (Upper left corner)

     

    2. Options and settings (bottom left)

    3. Data source settings

    After clicking on Data source settings you will see the below prompt and you can change the data source which you want.



    If this answers your questions, kindly accept it as a solution and give kudos.