Replacing a Excel table with a Database View

[Anonymous]

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.

[v-yulgu-msft · Accepted solution]

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