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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Replacing a Excel table with a Database View

I developed a dashboard from an Excel table. Now, I am able to get the same data from a database view.

I'm going to repeat all the data transformation processes (ETL) I did for the Excel table for the View by copying and changing the "M" code in the advanced editor, but since the view and the Excel table have different names how do I change the graphics reference to table columns. For example, visual elements that uses "excel table [sales]" column will need to be replaced to "view name [sales]". Since there are many elements, I ask if there is a more practical way of replacing all of them.

 

Thanks.

1 ACCEPTED SOLUTION
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @Anonymous,

 

There is no easy way to directly replace all the table/column names used in visuals at the same time. You may need to recreate the visuals in new report.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @Anonymous,

 

There is no easy way to directly replace all the table/column names used in visuals at the same time. You may need to recreate the visuals in new report.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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