topic Re: Issues with Power BI report server and Basic Authentication in Report Server

Issues with Power BI report server and Basic Authentication

JoostvB — Thu, 12 Oct 2017 08:41:03 GMT

Hi All,
I am facing an issue with Power BI Report Server (august preview version)
We have configured the Power BI report server to use Basic Authentication (<RSWindowsBasic/> in the rsreportserver.config file)
But now deployed Power BI reports throw an error (the Something went wrong message ) when I open the report for viewing.
Also Power BI reports that just contain a text label will not open.

The log file also shows errors related to this problem, here is a fragment from RSPowerBI log file:

2017-10-12 10:28:14.3631|ERROR|4|GetDataSource ERROR for catalogItem=b319987d-65cd-4bf5-9a70-d1d0cdc0adec, Exception=The format of value '<null>' is invalid., ElapsedMs=7| RequestID = 0d131cc1-61d5-8e4c-a9d2-9e8e3abd192f ClientSessionID = b7ecce4c-9ff5-7df2-f941-41993b719e65
2017-10-12 10:28:14.3631|ERROR|4|Failure in conceptualschema| RequestID = 0d131cc1-61d5-8e4c-a9d2-9e8e3abd192f ClientSessionID = b7ecce4c-9ff5-7df2-f941-41993b719e65 System.FormatException: The format of value '<null>' is invalid.
at Microsoft.PowerBI.ReportServer.WebApi.ASConnection.RSDataSourceProvider.GetDataSource(Int64 modelId)
at Microsoft.PowerBI.ReportServer.ExploreHost.RSPowerViewHandler.CreateModelKeyFromId(String modelIdFromClient)
at Microsoft.PowerBI.ReportServer.ExploreHost.RSPowerViewHandler.EnsureSession(String modelId)
at Microsoft.PowerBI.ExploreHost.ExploreClientHandlerBaseFlow.<RunAsync>b__8_0()
at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.ExploreHost.ExploreClient.<GetClientConceptualSchemaAsync>d__11.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.ReportServer.ExploreHost.RSExploreHost.<GetConceptualSchemaAsync>d__3.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.ReportServer.WebApi.PbiApi.PbiApiController.<GetConceptualSchemaAsync>d__d.MoveNext()
2017-10-12 10:28:14.3936|INFO|8|Sending response. Response code JoostPOC\Administrator 200, Elapsed time 0:00:00,6367781| RequestID = 0d131cc1-61d5-8e4c-a9d2-9e8e3abd192f ClientSessionID = b7ecce4c-9ff5-7df2-f941-41993b719e65

I also noticed that Power BI Desktop RS does not function when Power BI Report Server is set to Windows Basic Authentication, deploying Power BI reports won't work.
My question: is this a bug or is Power BI report server not supposed to work with Basic Authentication?
Thanks!
Joost

Re: Issues with Power BI report server and Basic Authentication

nghiatt — Thu, 12 Oct 2017 15:42:17 GMT

I have the same problem. Any help?

Re: Issues with Power BI report server and Basic Authentication

joaovitorpbc — Mon, 16 Oct 2017 15:15:40 GMT

I having the same problem too.

At Power BI Desktop it gives "Unexpected error encountered" at Power BI Report Server Selection window (Save as -> Power BI Report Server).

It doesn't work even with the format:

http://username:password@serveraddress/Reports

Re: Issues with Power BI report server and Basic Authentication

v-qiuyu-msft — Mon, 27 Nov 2017 14:20:57 GMT

Hi all,

I can reproduce this issue in Power BI report server August version as well. I follow this document to set Basic authentication, when view the Power BI report( this report can render fine before set Basic authentication) in web portal, below error occur:

When save the pbix file to report server, below error throws out:

riccardomuti mgmeyer chrisfin You can see attached log files. Is it a known issue?

Best Regards,
Qiuyun Yu

Re: Issues with Power BI report server and Basic Authentication

joaovitorpbc — Wed, 08 Nov 2017 14:38:33 GMT

@riccardomuti @mgmeyer @@chrisfi v-qiuyu-msft

Any news about this issue?

Re: Issues with Power BI report server and Basic Authentication

jtarquino — Thu, 09 Nov 2017 15:52:52 GMT

We are investigating the issue with the basic authentication rendering Power BI Reports.

For the other case reproted Power BI Desktop only supports integrated authentication when publishing to a Report Server

Thanks

-Jaime

Re: Issues with Power BI report server and Basic Authentication

dr-bcchr — Tue, 02 Jan 2018 19:26:54 GMT

This still appears to be affecting the latest release. Any update on the roadmap for fixing this bug?

Re: Issues with Power BI report server and Basic Authentication

jtarquino — Tue, 02 Jan 2018 19:32:08 GMT

What version are you using , we fixed the issue of rendering reports with basic authentication in november (https://docs.microsoft.com/en-us/power-bi/report-server/changelog)

We don't support the publishing of reports from PBI Desktop with basic authentication, you will need to use the portal

thanks

-Jaime

Re: Issues with Power BI report server and Basic Authentication

dr-bcchr — Wed, 10 Jan 2018 17:39:39 GMT

Thanks for reaching out! How do I submit a feature request for this?

Re: Issues with Power BI report server and Basic Authentication

jtarquino — Wed, 10 Jan 2018 17:42:39 GMT

You can submit it to https://ideas.powerbi.com

Re: Issues with Power BI report server and Basic Authentication

Anonymous — Fri, 02 Mar 2018 21:25:09 GMT

link gave me 404 in your post