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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
mrjizz
Frequent Visitor

Convert Dynamic URL to Static Power Query

I possess a dynamic URL in the format:

 

 

 

mrjizz_0-1716172510107.png

How can I transform this into a static URL within Power Query?

 

11 REPLIES 11
lbendlin
Super User
Super User

Please follow the documentation

Web.Contents - PowerQuery M | Microsoft Learn

use RelativePath and Query options.

I'm new to this, could you please tell me which part of my URL is Querry?

Query parameters are listed after the question mark in the URL. Your URLs don't have that, so in this particular case you only need RelativePath ( everything after the Site URL ).

Using the above method to switch to Static URL introduces authentication problems on the path. This is not an issue with Dynamic URL. 

mrjizz_1-1716186109157.png

 

 

Clear data source permissions and select the right method - Microsoft account. In the service that is called OAUTH2.

Is Web.Content required to be public data? I mean that my data needs to be private.

Web.Contents is just the name of the connector.  It can access any http(s) based data source.

Any solution for private data?

 

Your question is not clear to me. Please elaborate.

Is there any way to convert paths with private data?

mrjizz
Frequent Visitor

I've confirmed that all items within the square brackets [] are dynamic data. I've assigned them to variables and followed the method you described, but I'm still encountering issues.

mrjizz_0-1716193066222.png

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors