Changing an ODATA Target on a Table

[MNHGaming]

I am in Power Bi Desktop and my predecessor linked a lot of our reports to ODATA feeds who change, which means I get errors about adding in new columns etc. I'd like to create a copy of the feeds that will NOT be changing, but I'd love to change the table inside of PowerBI to this new report without having to rebuild all the table relationships etc again.

Example:

• We have an OData feed called INVOICE HISTORY
  • This is currently being used by Power BI
• I created a new OData feed (same URL, just another table in the list of OData feeds) that won't change called ODATA INVOICE HISTORY
  • I want this to be used by Power BI
• How do I change the table in Power BI pointing at INVOICE HISTORY to point at ODATA INVOICE HISTORY? They have the exact same columns and data, so I'm hoping I can just change the link to point to this new table without having to redo everything.

[MNHGaming]

I am connecting via ODATA as you show. Both tables are from the same URL. When you connect to that ODATA feed, you get a series of tables shown to you to choose from. How do I change what table it's pointing to without removing all the relationships/transformations etc?

Example: You connect to the ODATA FEED and you will see this (along with 50 other tables):

• INVOICE HISTORY
• ODATA INVOICE HISTORY

Right now INVOICE HISTORY is used extensively in my project. Without completely dropping that table from my model, can I somehow tell Power BI to use the ODATA INVOICE HISTORY table from the OData feed instead and perform the same transformations, keep the same relationships to other tables, etc. I'm hoping to avoid rebuilding all my views too who use elements from this table.

[Anonymous]

Hi @ MNHGaming ,

Currently, the feature you describe is not available in Power BI Desktop.

The relationship between the tables has been established after importing into Power BI Desktop. The visuals created based on the tables are also determined.

Unless of course you subsequently change them manually.

Unable to automatically replace one table with another without affecting relationships with other tables, etc.

You can only perform this process manually.

Manually remove relationships with other tables from the old table and join those relationships to the new table.

Change visual used fields from the old table to the new table.

You can create a new idea through the below URL, then ask your colleagues to raise up the votes.

 https://ideas.fabric.microsoft.com/ideas/

Our product team has direct visibility of these ideas, and they will implement it based on the highest number of votes received.

Best Regards,

Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @ MNHGaming ,

What method do you use to connect to the OData feed?

If you are connecting to the OData feed through the OData feed connector (as shown in the below images), then you can refer to the following steps to change the OData feed.

Enter the edit query interface by clicking /Transform Data/ on the command bar.

Find the table/query you want to change, go to the first step of the query (always called Source) and change the OData source here.

Best Regards,

Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.