Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
HaiVN
Helper II
Helper II

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

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!

1 ACCEPTED SOLUTION

Hello,

 

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

View solution in original post

8 REPLIES 8
v-nuoc-msft
Community Support
Community Support

Hi @HaiVN 

 

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

 

Regards,

Nono Chen

Hello,

 

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

v-nuoc-msft
Community Support
Community Support

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
Super User
Super User

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
Super User
Super User

@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



Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






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




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






Hi,

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

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

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors