Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
Solved! Go to Solution.
Hello,
Yes! Website manager helps to redirect from http to https and I do not need to do anything!
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!
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, 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.
@HaiVN , You can use below m code to replace this words
Proud to be a Super User! |
|
Yes once for every report and you can also check @Sergii24 ,'s response
Proud to be a Super User! |
|
Hi,
Website manager helps to redirect from http to https and I do not have to do anything!
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
105 | |
98 | |
39 | |
30 |