Need a shortcut to update queries in Power BI report

[Sunkari]

Hi All,

I have a .pbix file which contains more than 40 queries. I need to update underlying queries. I thought of doing directly in the source code of .pbix file.  I unzipped .pbix and seeing multiple files.

I am not sure where(which file) make the changes and how to open the underlying files.

Please provide your inputs here.

[vanessafvg]

what exactly are you going to change?

[Sunkari]

Need replace SQL query behind all power bi model tables

[v-qiuyu-msft]

Hi @Sunkari,

As far as I know, you need to open Query Editor -> Advanced Editor to modify T-sql query separately for each table.

Best Regards,
Qiuyun Yu