October 2020 - Unable to Save File to Report Server

BenMackin — Thu, 21 Jan 2021 20:31:14 GMT

I am having a similar issue as posted about here. Using the latest version of Power BI Desktop for Report Server (2.86.1321.0) and Server (Version: 1.9.7675.15620 (Build 15.0.1104.300)) I am unable to upload or save a file which references a function that takes a parameter as a value.

Error when doing Save As from within Power BI Desktop:

Error when trying to upload the file via Chrome:

Function - Real Name Lookup:

(sharePointSite, listName)=> let Source = OData.Feed("https://am-regional.internalspsite.com/sites/CRA/_api/web/lists/GetByTitle('" & listName & "')/Fields?$select=Title,InternalName", null, [Implementation="2.0"]), #"Replaced Value" = Table.ReplaceValue(Source,"_x002d_","-",Replacer.ReplaceText,{"InternalName"}), #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","_x0020_"," ",Replacer.ReplaceText,{"InternalName"}), recs = Table.ToRecords(#"Replaced Value1"), lsts = List.Transform(recs, each Record.ToList(_)) in lsts

Query - High Level Business Line:

let Source = SharePoint.Tables("https://am-regional.internalspsite.com/sites/CRA/", [ApiVersion = 15]), #"2cc193b4-d0e8-4ee2-ae77-a0f03817d347" = Source{[Id="2cc193b4-d0e8-4ee2-ae77-a0f03817d347"]}[Items], #"Renamed Columns" = Table.RenameColumns(#"2cc193b4-d0e8-4ee2-ae77-a0f03817d347",{{"ID", "ID.1"}}), #"Renamed Fields"=Table.RenameColumns(#"Renamed Columns", #"Real Name Lookup"("https://am-regional.internalspsite.com/sites/CRA/","High Level Business Line"), MissingField.Ignore) in #"Renamed Fields"

As soon as I remove the listName parameter from the function call in the OData.Feed, and hard code it with a string value like so:

Source = OData.Feed("https://am-regional.internalspsite.com/sites/CRA/_api/web/lists/GetByTitle('High Level Business Line')/Fields?$select=Title,InternalName", null, [Implementation="2.0"]),

the file will upload and save just fine.

So it appears there is some kind of an issue with making use of paramters right now in certain contexts?

Re: October 2020 - Unable to Save File to Report Server

Anonymous — Tue, 26 Jan 2021 02:30:16 GMT

BenMackin

Thank you for share, we will investigate this issue.

Paul Zheng _ Community Support Team

Re: October 2020 - Unable to Save File to Report Server

Anonymous — Mon, 01 Feb 2021 01:55:56 GMT

BenMackin

Solved: Power BI Report Server Oct 2020 Unable to save whe... - Microsoft Power BI Community

The issue is fixed with the newest version, please update and try again.

Best Regards
Paul

Re: October 2020 - Unable to Save File to Report Server

BenMackin — Mon, 01 Feb 2021 17:19:37 GMT

As soon as we get this version installed in our test environment, I'll try it out. It will probably take us a week or two.

topic Re: October 2020 - Unable to Save File to Report Server in Report Server

October 2020 - Unable to Save File to Report Server

Re: October 2020 - Unable to Save File to Report Server

Re: October 2020 - Unable to Save File to Report Server

Re: October 2020 - Unable to Save File to Report Server