Reply
ConnieMaldonado
Responsive Resident
Responsive Resident
Partially syndicated - Outbound

POINT to a Different Database

I have a report created from a table in which I've created many formulas and measures.  I need to import a new table (not possible to update the current table).  Is there anyway to point the current database to the new table and maintain the formulas and measures or do I have to recreate them in the new table?

 

Hope this makes sense.  Thanks.

1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

Syndicated - Outbound

If the table was loaded through the query editor, then you could change the query to the new source and your existing measure should still be there. One way to do this would be to create a new query to connect to the new table and then copy and paste the M code from that query (from the Advanced Editor) over the M code of the old query.

View solution in original post

1 REPLY 1
AlexisOlson
Super User
Super User

Syndicated - Outbound

If the table was loaded through the query editor, then you could change the query to the new source and your existing measure should still be there. One way to do this would be to create a new query to connect to the new table and then copy and paste the M code from that query (from the Advanced Editor) over the M code of the old query.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)