How to Change Data Source Type and Location

[Shelley]

In order to prototype a new report, I was using a load from an Excel file and a load from a SharePoint list. Each of these tables has now been loaded into our Azure server. How can I change each of these data sources to now point to their respective new Azure data tables? When I go into Edit Queries and try to change the source of each item, it seems to only let me change the Excel file to another Excel file and the SarePoint list to another SharePoint list. I'm concerned I will have to load each of the new tables and then recreate all of my expressions. There must be an easier way. If not, Microsoft should work this feature into the product to make this very easy for content creators. Thanks in advance for the help!

[Shelley · Accepted solution]

I figured out how to do this kind of easily.

I brought my new tables into my pbix file thru Get Data.

I then went into Edit Queries, and made any data type and field name revisions to the new tables so they are just how I need them.

I then clicked on my first new table and clicked on Advanced Editor. I selected everything in this window and copied it (CTRL-C). I clicked Cancel to get out of the window. Then I went to my original table from the SharePoint site by clicking on it. Then I clicked on Advanced Editor, selected everything in this window and pasted everything I had copied from my new table over the old information. This essentially copies all the new source information and modifications onto the original table.

I followed the same steps for the other Excel file to convert it to the Azure data source.