Pre-filter large SharePoint Online list before importing via ODATA
Hi, I want to prefilter and then import a large SharePoint Online list (more than 100k items) with ODATA and get following error: I have a list with the same structure and only 2k items in it. For this list it works this way without problems. What can I do to solve this issue for the large list. Thanks for your help. Michael
OData authentication to Power BI Report Server shared dataset
Hello everyone, We're trying to create reports using the same dataset so we can reuse them e don't use a lot o space replicating Power BI Reports. So, we create a datasource and a dataset using Report Builder. So far we have been able to make everything work. The only way that we could find to create Power BI Reports using this dataset, is using OData Feed (according to PBI doc and some posts in this community). So, I created the report using the URL http://powerbi/reports/api/v2.0/DataSets(dataset-id)/data and could get the data successfully. After I published the report to the Report Server, I could open and view the visualizations. But when I try to update the data (through update button or schedule refresh) it won't work. When I go to credentials and try to connect using the same credentials used in Power BI Desktop (while creating the report) it won't connect and give the message "Log on failed. Ensure the user name and password are correct." Can you anyone help me understanding what am I missing? Thank you in advance!
OData Credentials- Couldn't connect msg
Hello, Could you please help me with the below Issue, When I connect to the OData feed from Power BI Desktop, I can connect, import data, and create reports. OData URIs Example: https://localhost:7048/BC230/ODataV4/Company('CRONUS International Ltd.')/Customer?$filter=City eq 'Miami' 1- If I don't specify the /Customer?$filter=City eq 'Miami' (bring only Customer and apply a filter or select only needed columns in the OdataFeed using $filter and $select) I don't get any refresh problems when publishing the report in Power BI Report Server, Data Source credentials connect successfully and I can create a scheduled refresh. 2- I only get the below problem after adding /Customer?$filter=City eq 'Miami' When I publish the report to our internally hosted Power BI Report Server,I get a red x Couldn't Connect with the following message Here I am Using the same credentials, as in 1- However, I can create a scheduled refresh and the report does refresh successfully(Status=Completed Data Refresh). Note: I am connected to Microsoft Dynamics 365 Business Central What do you think the problem is? a Bug in Power BI Report Server or a setting in BC?Automatic refresh OData
Hi, I used OData in Power BI. I want to set up automatic refresh but I'm getting an error. I am pulling data into Power BI with the gateway on another employee's computer, but I cannot see this gateway in online Power BI. As in the image below: Also, I cannot update in online Power BI and I get the following error: When I enter the connection settings in the 'Manage Connection and Dataset' area, I select basic as the authentication method. I enter the username and password I have to access the data. The save button is active, but nothing happens when I click it. (Extra information: Gateway Cluster Name: personal mode). Where am I making a mistake? Also, as far as I know, in this scenario the computer must be on during the automatic renewal process. Is there a way to automatically refresh data that does not require the computer to be turned on?
OData exception occurred: System.Net.WebException: The remote server returned an error: (503) Server
This error is returned when a report request is issued like: GET 'http://localhost/reports/api/v2.0/CatalogItems(Path='/TestDUO/Test')' (~/entityset/key) Getting 'CatalogItems(Path='/TestDUO/Test')' Getting service state using: http://servername/powerbi/api/servicestate In the trace log we see the next lines: at System.Net.HttpWebRequest.GetResponse() at Microsoft.ReportingServices.Portal.ODataWebApi.Utils.PbixReportHelper.ShouldReShred(PowerBIReport entity, Uri basePortalUrl, ILogger logger, IPrincipal userPrincipal, String reportServerHostName) at Microsoft.ReportingServices.Portal.ODataWebApi.Common.CatalogItemControllerHelper`1.GetItem(String key) at Microsoft.ReportingServices.Portal.ODataWebApi.Common.CatalogItemControllerHelper`1.GetAllowedActions(String Id) at Microsoft.ReportingServices.Portal.ODataWebApi.V2.Controllers.PowerBIReportsController.GetAllowedActions(String Id) at lambda_method(Closure , Object , Object[] ) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.<GetExecutor>b__2(Object instance, Object[] methodParameters) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken) --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__6.MoveNext(). What might cause this error?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
