cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ojasmaru Frequent Visitor
Frequent Visitor

Error in refreshing Power BI report based off OData connection in Custom authentication mode

I am unable to refreseh Power BI Reports based off OData service uploaded in PBI RS which used custom authentication. Following are the logs from RSPowerBI

 

2018-03-23 16:11:02.2304|INFO|6|Handling event with data: TimeEntered: 3/23/2018 11:11:00 PM, Type: Event, SessionId: 532cc6cd-d84a-4388-8531-35c884795c79, EventType: DataModelRefresh

2018-03-23 16:11:02.3954|INFO|6|Processing Data Model Refresh: SessionId: 532cc6cd-d84a-4388-8531-35c884795c79, Status: Starting Data Refresh.

2018-03-23 16:11:02.4164|INFO|6|Processing Data Model Refresh: SessionId: 532cc6cd-d84a-4388-8531-35c884795c79, Status: Starting Retrieving PBIX AsDatabaseInfo.

2018-03-23 16:11:02.4503|INFO|6|Processing Data Model Refresh: SessionId: 532cc6cd-d84a-4388-8531-35c884795c79, Status: Starting Verifying all the data sources are embedded.

2018-03-23 16:11:02.4503|INFO|6|Processing Data Model Refresh: SessionId: 532cc6cd-d84a-4388-8531-35c884795c79, Status: Starting Verifying connection strings are valid.

2018-03-23 16:11:02.4582|INFO|6|Processing Data Model Refresh: SessionId: 532cc6cd-d84a-4388-8531-35c884795c79, Status: Starting Streaming model to Analysis Server.

2018-03-23 16:11:02.4860|ERROR|6|Error Processing Data Model Refresh: SessionId: 532cc6cd-d84a-4388-8531-35c884795c79, Status: Error Failed Streaming model to Analysis Server, Exception System.AggregateException: One or more errors occurred. ---> System.AggregateException: One or more errors occurred. ---> System.ArgumentNullException: Value cannot be null.

Parameter name: s

   at System.IO.StringReader..ctor(String s)

   at System.Xml.Linq.XDocument.Parse(String text, LoadOptions options)

   at Microsoft.ReportingServices.CatalogAccess.PolicyAcessor.<GetItemPolicies>d__3.MoveNext()

   --- End of inner exception stack trace ---

   at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)

   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.<LoadDatabase>d__10.MoveNext()

   --- End of inner exception stack trace ---

   at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)

   at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)

   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.LoadModel(AsDatabaseInfo asDatabaseInfo)

   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<>c__DisplayClass9.<ExecuteActionWithLogging>b__7()

   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<ExecuteFuncWithLogging>d__3`1.MoveNext()

---> (Inner Exception #0) System.AggregateException: One or more errors occurred. ---> System.ArgumentNullException: Value cannot be null.

Parameter name: s

   at System.IO.StringReader..ctor(String s)

   at System.Xml.Linq.XDocument.Parse(String text, LoadOptions options)

   at Microsoft.ReportingServices.CatalogAccess.PolicyAcessor.<GetItemPolicies>d__3.MoveNext()

   --- End of inner exception stack trace ---

   at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)

   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.<LoadDatabase>d__10.MoveNext()

---> (Inner Exception #0) System.ArgumentNullException: Value cannot be null.

Parameter name: s

   at System.IO.StringReader..ctor(String s)

   at System.Xml.Linq.XDocument.Parse(String text, LoadOptions options)

   at Microsoft.ReportingServices.CatalogAccess.PolicyAcessor.<GetItemPolicies>d__3.MoveNext()<---

<---

 

2018-03-23 16:11:02.5050|ERROR|6|Error Processing Data Model Refresh: SessionId: 532cc6cd-d84a-4388-8531-35c884795c79, Status: Error Failed Data Refresh, Exception System.ArgumentNullException: Value cannot be null.

Parameter name: s

   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.ExecuteActionWithLogging(Action methodToExecute, String description, String localizedDescription, String messageInFailure, RefreshInfo refreshInfo, DataAccessors dataAccessors, ReportEventType operation, Boolean isDataRetrieval, Boolean showInExecutionLog, Boolean sendToTelemetry)

   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.RefreshData(RefreshInfo refreshInfo)

   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<>c__DisplayClass9.<ExecuteActionWithLogging>b__7()

   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<ExecuteFuncWithLogging>d__3`1.MoveNext()

 

 

I could run SQL trace and it looks like the issue is with calling SPs with wrong AuthType value

 

exec GetCatalogItemProperties @CatalogItemID=N'54c2330e-9b69-4bdd-a3d0-8c6a18b15e1f'

 

--PBI RS code makes this call

exec GetPolicyByItemId @ItemId='54C2330E-9B69-4BDD-A3D0-8C6A18B15E1F',@AuthType=1

 

--I am assuming it should be making this call with @AuthType=3

exec GetPolicyByItemId @ItemId='54C2330E-9B69-4BDD-A3D0-8C6A18B15E1F',@AuthType=3

 

 

 

GetPolicyItemByIdIssue.png

 

 

 

1 REPLY 1
Highlighted
mickwang Frequent Visitor
Frequent Visitor

Re: Error in refreshing Power BI report based off OData connection in Custom authentication mode

Hi , Sir, have you solved this problem? I met the same problem.

 

And what do you mean by the "AuthType" value?

 

thank you