Forum Discussion

mrjizz's avatar
mrjizz
Frequent Visitor
2 years ago

Convert Dynamic URL to Static Power Query

I possess a dynamic URL in the format:       How can I transform this into a static URL within Power Query?  
Refresh Power Bi service
mrjizz's avatar
mrjizz
Frequent Visitor
2 years ago

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

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

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's avatar
    mrjizz
    Frequent Visitor
    2 years ago

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

     

     

    • mrjizz's avatar
      mrjizz
      Frequent Visitor
      2 years ago

      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.

       

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

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

      • mrjizz's avatar
        mrjizz
        Frequent Visitor
        2 years ago

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