Forum Discussion

rds_2019's avatar
rds_2019
Helper I
6 years ago
Solved

Change Report's Data Source

Hi All, My Report is using Excel Table as a Data Source. After processing i have to create another Appended Table, which i would like to use as a data source How can i change current Data source ex...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi rds_2019 ,

     

    Based on your describle, We did some tested on it, your first solution should works fine, just change the query of table1 to the following in the Advanced Editor, But never forget to make backup of pbix file.

     

     

    Append__Table1

     

     

     

    After reference to the append table, all your visual and measure releated to old table will still exist.

     


    BTW, pbix as attached.

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

rds_2019's avatar
rds_2019
Helper I
6 years ago

Hi jdbuchanan71  ,

Thanks for replying, how can add Appended Table as a source to the New Table coz Table created by Appending 2 excels doesnt show up in the browser to be added as a source.

 

RDS

jdbuchanan71's avatar
jdbuchanan71
Super User
6 years ago

You would pull in each file as it's own query then combine them in an append query and make the output of the combined append the source you send into the model.

  • rds_2019's avatar
    rds_2019
    Helper I
    6 years ago

    Hi jdbuchanan71 

    I tried to understand what is written by you but dont know how to do it

     

    Let me clarify my question further .

    I am using Table1 which is an excel table and have created Dashboard based on it.

    Now the data sources has increased so I have created 

    Append__Table1 by adding 2 different Excels= Table3 Appended with Table4.

     

    No I want to replace data source of Dashboard using Table1 to Append_Table1.

     

    I have got 2 ways to do it as per my understanding.

     

    1.Make changes to query of Table1 and make it refer to Append_Table(Since Latest table is Appended Table , I cant just replace to it since it doesnt show up as an option)

    2.Replace Data Source of Dashboard to another Table -Appened_Table1

     

    So which would be right way to do it and how to get it done?

     

     

    regards,

    RDS

     

    • jdbuchanan71's avatar
      jdbuchanan71
      Super User
      6 years ago

      rds_2019 

      Can you share you .pbix file so I can see the step you have applied and the layout of the tables?

    • v-lid-msft's avatar
      v-lid-msft
      Community Support
      6 years ago

      Hi rds_2019 ,

       

      Based on your describle, We did some tested on it, your first solution should works fine, just change the query of table1 to the following in the Advanced Editor, But never forget to make backup of pbix file.

       

       

      Append__Table1

       

       

       

      After reference to the append table, all your visual and measure releated to old table will still exist.

       


      BTW, pbix as attached.

       

      Best regards,

      Community Support Team _ Dong Li
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • rds_2019's avatar
        rds_2019
        Helper I
        6 years ago

        Thanks v-lid-msft  this was simple, simple reference to the APPEND_TABL1. didnt get any option so wasnt sure how to refer to the table which is not physical and not showing up in the browser