How to migrate report that uses App Insights API in M query as a source across environments?

[sharmisaranga09]

Hi,

I have created a report for Usage data of customer application, logs from App Insights are connected to powerbi using M query.

Is there a way to migrate this report from one environment to another, like change the source so that the data comes from QA right now it's DEV.

[Anonymous · Accepted solution]

Hi @sharmisaranga09 

You can consider to create a new paramater in power query. you can put your url in the paramater, then in M code , change the source to the paramater, you can refer to the following link.

https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.