Forum Discussion
Changing an ODATA Target on a Table
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.
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.