Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ConnieMaldonado
Responsive Resident
Responsive Resident

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

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

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.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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