Change from "http" to "https" in Power BI querry

HaiVN , You can use below m code to replace this words

Hi HaiVN, this is an excellent example for using dataflows (What are Power BI Dataflows and their Use Cases? - RADACAD). If you already use it, then you ca proceed directly with bhanu_gautam's suggestion.

 

If data transformation happens independetly in each of your 50 reports, then you'd need to update them one by one. However I'd strongly suggest you to consider dataflows before doing it. It will save you from a similar issue if happens again.

Hi HaiVN

 

Thank you very much bhanu_gautam and Sergii24 for your prompt reply. Please allow me to add a few details about dataflows.

 

Dataflows allows you to centrally manage the data transformation logic, making it easier to apply changes across multiple reports.

 

In the Power BI service, select your workspace, and create a dataflow by using define new tables.

 

Connect to your data source.

 

Use the Dataflow editor (similar to Power Query) to transform and clean the data.

 

Here, you can replace "http://" with "https://" using the Text.Replace function.

 

Change the data source of an existing report in power bi desktop to fetch data from Dataflow instead of directly from the original data source.

 

You can view the link below for more details:

 

Creating a dataflow - Power BI | Microsoft Learn

 

Configure and consume a dataflow - Power BI | Microsoft Learn

 

Regards, 

Nono Chen 

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

Hi HaiVN 

 

Can you tell me if your problem is solved? If yes, please accept it as solution.

 

Regards,

Nono Chen