topic Re: Power BI Report Server Oct 2020 Unable to save when Jason URL contains parameter in URL in Report Server

Power BI Report Server Oct 2020 Unable to save when Jason URL contains parameter in URL

Anonymous — Fri, 15 Jan 2021 04:30:44 GMT

Parameters for JSON API data

All look ok with (Build 15.0.1104.300), Released: January 8, 2021 but >>>

Parameters for JSON API data in URL with parameter works great in Power Desktop

BUTcannot be deployed or saved in PBI Report Server when ason URL contains parameter in URL

let

sqltext = ( usr as text) =>

let

UR = Web.Contents("https://api.webappl.com.au/users/" & usr & "/tags", [Headers=[ContentType="application/json", Authorization="######"]]),

Source = Json.Document(UR),

I cannotsave updated report to Power BI Server after upgrading to Power BI Server October 2020 (Build 15.0.1104.264) or (Build 15.0.1104.300), Released: January 8, 2021.

Could someone share any workaround to this issue ?

Re: Power BI Report Server Oct 2020 Unable to save when Jason URL contains parameter in URL

v-janeyg-msft — Mon, 18 Jan 2021 10:05:58 GMT

Hi, Anonymous

Can you show screenshots or error messages that can't be saved?

Is it normal to write this before the updated version?

Bset Regards

Janey Guo

Re: Power BI Report Server Oct 2020 Unable to save when Jason URL contains parameter in URL

Anonymous — Mon, 18 Jan 2021 23:00:33 GMT

Re: Power BI Report Server Oct 2020 Unable to save when Jason URL contains parameter in URL

FarhanAhmed — Tue, 19 Jan 2021 05:45:53 GMT

Have you tried to upload a report from Power BI Report Server and see if a same error exists?

There seems to be a problem with resolving Server Names & IPs which is causing you to stop the report saving on PBIRS directly from the desktop.

Re: Power BI Report Server Oct 2020 Unable to save when Jason URL contains parameter in URL

Anonymous — Tue, 19 Jan 2021 05:56:28 GMT

Re: Power BI Report Server Oct 2020 Unable to save when Jason URL contains parameter in URL

v-janeyg-msft — Tue, 19 Jan 2021 06:24:50 GMT

Hi, Anonymous

Is there a problem with only this report containing the api url or all reports has problems?

Try to turn off the enhanced format feature,it may be help.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Power BI Report Server Oct 2020 Unable to save when Jason URL contains parameter in URL

FarhanAhmed — Tue, 19 Jan 2021 06:30:46 GMT

Make sure you are using correct version of PBI desktop optimzed for PBIRS to creating reports.

Re: Power BI Report Server Oct 2020 Unable to save when Jason URL contains parameter in URL

Anonymous — Tue, 19 Jan 2021 07:16:28 GMT

No, it did not help by turn off the enhanced format in Power BI Desktop October 2020

Issue is in URL that includes parameters

Re: Power BI Report Server Oct 2020 Unable to save when Jason URL contains parameter in URL

Anonymous — Tue, 19 Jan 2021 07:25:15 GMT

It only happend when URL includes parameters .. Parker Stevens uses a similar sample in below video link but works only in Power Desktop

Easy Looping in Power BI & Power Query | BI Elite

Re: Power BI Report Server Oct 2020 Unable to save when Jason URL contains parameter in URL

v-janeyg-msft — Wed, 20 Jan 2021 02:05:31 GMT

Hi, Anonymous

If you can upload normally using url parameter in the previous version, but not after upgrading, you can try to install the lower version.

Reference:Support timeline for Power BI Report Server - Power BI | Microsoft Docs

Download Microsoft Power BI Report Server - May 2020 from Official Microsoft Download Center

By the way, Try not to use the same name in PQ.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Power BI Report Server Oct 2020 Unable to save when Jason URL contains parameter in URL

Anonymous — Fri, 29 Jan 2021 02:10:23 GMT

Good News !Issue has been FIXED in Microsoft Power BI Report Server - January 2021

https://www.microsoft.com/en-us/download/details.aspx?id=55329

Check

Change log for Power BI Report Server 01/28/2021
This change log is for Power BI Report Server and lists new items along with bug fixes for each released build.
See What's new in Power BI Report Server for more information about new features.
January 2021

https://docs.microsoft.com/en-us/power-bi/report-server/changelog