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

[Anonymous]

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

[Mike_Mellis]

Did anyone find a solution to this?  I have a similar issue for ERROR|76, There is no data in the database for @CatalogItemId.

https://community.powerbi.com/t5/Report-Server/Scheduled-Refresh-error-quot-There-is-no-data-in-the-...

[mickwang]

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

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

thank you