topic Re: Convert Dynamic URL to Static Power Query in Report Server https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3936231#M35002 <P>Any solution for private data?</P><P>&nbsp;</P> Tue, 21 May 2024 13:40:30 GMT mrjizz 2024-05-21T13:40:30Z Convert Dynamic URL to Static Power Query https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3929236#M34969 <P>I possess a dynamic URL in the format:</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mrjizz_0-1716172510107.png" style="width: 744px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1101270i67CCFAA6FFC0158D/image-dimensions/744x93?v=v2" width="744" height="93" role="button" title="mrjizz_0-1716172510107.png" alt="mrjizz_0-1716172510107.png" /></span></P><P>How can I transform this into a static URL within Power Query?</P><P>&nbsp;</P> Mon, 20 May 2024 02:35:46 GMT https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3929236#M34969 mrjizz 2024-05-20T02:35:46Z Re: Convert Dynamic URL to Static Power Query https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3929837#M34970 <P>Please follow the documentation</P> <P><A href="https://learn.microsoft.com/en-us/powerquery-m/web-contents" target="_blank">Web.Contents - PowerQuery M | Microsoft Learn</A></P> <P>use RelativePath and Query options.</P> Sat, 18 May 2024 19:30:42 GMT https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3929837#M34970 lbendlin 2024-05-18T19:30:42Z Re: Convert Dynamic URL to Static Power Query https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3930476#M34976 <P><SPAN>I'm new to this, could you please tell me which part of my URL is Querry?</SPAN></P> Sun, 19 May 2024 11:26:37 GMT https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3930476#M34976 mrjizz 2024-05-19T11:26:37Z Re: Convert Dynamic URL to Static Power Query https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3930514#M34977 <P>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 ).</P> Sun, 19 May 2024 12:03:48 GMT https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3930514#M34977 lbendlin 2024-05-19T12:03:48Z Re: Convert Dynamic URL to Static Power Query https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3931555#M34982 <P>Using the above method to switch to Static URL introduces authentication problems on the path. This is not an issue with Dynamic URL.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mrjizz_1-1716186109157.png" style="width: 772px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1101387iD7F923F5450D4395/image-dimensions/772x463?v=v2" width="772" height="463" role="button" title="mrjizz_1-1716186109157.png" alt="mrjizz_1-1716186109157.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Mon, 20 May 2024 08:14:45 GMT https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3931555#M34982 mrjizz 2024-05-20T08:14:45Z Re: Convert Dynamic URL to Static Power Query https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3931820#M34983 <P><SPAN>I've confirmed that all items within the square brackets </SPAN>[]<SPAN> are dynamic data.</SPAN><SPAN> I've assigned them to variables and followed the method you described,</SPAN><SPAN> but I'm still encountering issues.</SPAN></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mrjizz_0-1716193066222.png" style="width: 675px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1101469iFF04CE5C5556930D/image-dimensions/675x108?v=v2" width="675" height="108" role="button" title="mrjizz_0-1716193066222.png" alt="mrjizz_0-1716193066222.png" /></span></P><P>&nbsp;</P> Mon, 20 May 2024 08:18:48 GMT https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3931820#M34983 mrjizz 2024-05-20T08:18:48Z Re: Convert Dynamic URL to Static Power Query https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3932004#M34986 <P>Clear data source permissions and select the right method - Microsoft account. In the service that is called OAUTH2.</P> Mon, 20 May 2024 09:35:33 GMT https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3932004#M34986 lbendlin 2024-05-20T09:35:33Z Re: Convert Dynamic URL to Static Power Query https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3933778#M34994 <P>Is Web.Content required to be public data? I mean that my data needs to be private.</P> Tue, 21 May 2024 01:55:31 GMT https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3933778#M34994 mrjizz 2024-05-21T01:55:31Z Re: Convert Dynamic URL to Static Power Query https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3933782#M34995 <P>Web.Contents is just the name of the connector.&nbsp; It can access any http(s) based data source.</P> Tue, 21 May 2024 01:58:01 GMT https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3933782#M34995 lbendlin 2024-05-21T01:58:01Z Re: Convert Dynamic URL to Static Power Query https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3936231#M35002 <P>Any solution for private data?</P><P>&nbsp;</P> Tue, 21 May 2024 13:40:30 GMT https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3936231#M35002 mrjizz 2024-05-21T13:40:30Z Re: Convert Dynamic URL to Static Power Query https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3936999#M35005 <P>Your question is not clear to me. Please elaborate.</P> Tue, 21 May 2024 19:47:02 GMT https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3936999#M35005 lbendlin 2024-05-21T19:47:02Z Re: Convert Dynamic URL to Static Power Query https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3938196#M35014 <P>Is there any way to convert paths with private data?</P> Wed, 22 May 2024 06:29:16 GMT https://community.fabric.microsoft.com/t5/Report-Server/Convert-Dynamic-URL-to-Static-Power-Query/m-p/3938196#M35014 mrjizz 2024-05-22T06:29:16Z