Convert Dynamic URL to Static Power Query

[mrjizz]

I possess a dynamic URL in the format:

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

[lbendlin]

Please follow the documentation

Web.Contents - PowerQuery M | Microsoft Learn

use RelativePath and Query options.

[mrjizz]

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

[lbendlin]

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 ).

[mrjizz]

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

[lbendlin]

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

[mrjizz]

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

[lbendlin]

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

[mrjizz]

Any solution for private data?

[lbendlin]

Your question is not clear to me. Please elaborate.

[mrjizz]

Is there any way to convert paths with private data?

[mrjizz]

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.