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.