Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
FernSant
Helper I
Helper I

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

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 ?

1 ACCEPTED SOLUTION
FernSant
Helper I
Helper I

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

View solution in original post

10 REPLIES 10
FernSant
Helper I
Helper I

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

v-janeyg-msft
Community Support
Community Support

Hi, @FernSant 

 

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

 my log Capture.PNGSaving to Report ServerCapture.PNGAPI_Function_Capture.PNG

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.

 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




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

 

 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




Hi, @FernSant 

 

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.

8.png

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.

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

 

Issue is in URL that includes parameters 

API_Function_Capture.PNG

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

 

 

Hi, @FernSant 

 

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors