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

[HaiVN]

Hello,

I have several Power BI repports which are published i POwer BI service. Repports get data from a web API. I found that i have to change the website address at Power BI querry from "http//" to "https". I have about 50 repports with more than 2 querries per repport. I wonder if I can change the automaticlly?

Many thanks!

[Anonymous]

Hi @HaiVN 

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

Regards,

Nono Chen

[HaiVN · Accepted solution]

Hello,

Yes!  Website manager helps to redirect from http to https and I do not need to do anything!

[Anonymous]

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. 

[Sergii24]

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.

[bhanu_gautam]

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

let

    Source = Web.Contents("http://example.com/api/data"),

    ReplacedSource = Text.Replace(Source, "http://", "https://")

in

    ReplacedSource

[bhanu_gautam]

Yes once for every report and you can also check @Sergii24 ,'s response

[HaiVN]

Hi,

Website manager helps to redirect from http to https and I do not have to do anything!

[HaiVN]

@bhanu_gautam  Do I have to do it in all rapporter? 
Cheers!