Forum Discussion

JoostvB's avatar
JoostvB
Regular Visitor
8 years ago

Issues with Power BI report server and Basic Authentication

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


Power BI Report Server Basic Authentication

10 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    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 mgmeyerchrisfin You can see attached log files. Is it a known issue?

     

    Best Regards,
    Qiuyun Yu 

      • jtarquino's avatar
        jtarquino
        Microsoft Employee
        8 years ago

        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

  • joaovitorpbc's avatar
    joaovitorpbc
    Regular Visitor
    8 years ago

    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