Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I possess a dynamic URL in the format:
How can I transform this into a static URL within Power Query?
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.
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?
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.