Because of this error, our whole report system is totally disconnected from the Test folder. Please advise to this case.   Request ID: 501579f5-c87f-32d0-37c4-69bdedc52fee Correlation ID: 2d9bc82c-adfb-d9d9-4d16-8757b6c087c1 Time: 8/9/2022, 8:50:24 AM Service version: 13.0.18800.35 Client version: 2208.1.12628-train Cluster URI: https://wabi-paas-1-scus-redirect.analysis.windows.net/ ... View more

I've implemented the Personalize Visuals feature on the scatter charts in a report that I am developing, in which scientific/technical data is displayed and can be explored. It works quite well, but testing has revealed a couple of issues that are preventing the full roll-out of this feature:   1. There does not appear to be a way for the user to change the axis type between linear and logarithmic. Without this, I would have to use the 'hack' of making four versions of each graph (with lin-lin, lin-log, log-lin, and log-log axes) and using bookmarks and buttons to switch between them. However, this of course isn't ideal, and would have the effect of 'resetting' the graph's contents (to whatever is set up for the bookmark) each time (instead of just changing the axis type and leaving the data selection unchanged).   2. When the user chooses a new field for one of the axes, the numerical data is summarised (using 'Sum') by default. This is not something that you typically want when plotting technical data. In the worst case, the user might not notice that the data has been summed up, and could draw incorrect conclusions. It would be much better if "Don't summarize" was the default option here, or perhaps the report developer could choose the default summarisation method when configuring the visual.   It would be great if the Power-BI development team could take these points as feedback / feature requests, and if someone could help with any other workarounds, that would also be appreciated.   Many thanks! ... View more

Hello all,    I published an excel as dataset (Publish to Power Bi -> Export). It is now located in My Workspace.    Then I opened an existing project on Power Bi Desktop. This project already has a dataset and I wanted to add one more. I tried to get data -> Power Bi Datasets.    All the other datasets appear in the list except of the one that I published from Excel.    In order to understand the issue I started a new Power Bi project and there I could access this dataset. But when I tried to add another dataset, I can not!!!    It seems that when you publish a dataset from excel, you can not combine this dataset with ny other one.  All other options are greyed out.    Could you please advise?    Kind regards,  Mirellou  ... View more

We have a report that is published on Teams as a PowerBI tab. The report is not visible in the Desktop version of Teams, but if we open the web version the report is visible. Any ideas?  ... View more

I have an issue and I could not find an explanation for it. In teams, we have multiple tabs with power bi reports. For some of them, I am able to select the report shown in that specific tab. For others, this option is not possible and if I want to change the report I have to delete the tab and recreate a new one with the new report. Please see attached the 2 screenshots that are reflecting this situation (what can cause the difference between these 2 tabs). Any thoughts/ideas will be much appreciated.   ... View more

Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net Activity ID: e7c66f5c-02f5-4f4d-afbc-fa47effe7088 Request ID: 0b6cd8a5-78ea-4414-bb84-193d8942b37b Time: 2022-08-06 18:11:02Z ... View more

I'm getting this error when trying to set up a dataflow to connect to an API. "DataSource.Error: OData: Request failed: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel." I've tested trying to call the API from Power BI Desktop and that works fine. Not sure why this is not working when trying to use it in a dataflow. ... View more

Hi, Need help, I can't open pbi dekstop, I've tried install from microsoft store and offline installer and got the same issues!   Feedback Type: Frown (Error) Timestamp: 2022-08-08T13:04:43.3356600Z Local Time: 2022-08-08T20:04:43.3356600+07:00 Session ID: b6391881-bc19-4005-9a2f-6b643a388eef Release: July 2022 Product Version: 2.107.841.0 (22.07) (x64) Stack Trace: Microsoft.AnalysisServices.ConnectionException at Microsoft.AnalysisServices.XmlaClient.OpenConnectionAndCheckIfSessionTokenNeeded(ConnectionInfo connectionInfo) at Microsoft.AnalysisServices.XmlaClient.OpenConnection(ConnectionInfo connectionInfo, Boolean& isSessionTokenNeeded) at Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) at Microsoft.AnalysisServices.Core.Server.Connect(String connectionString, String sessionId, ObjectExpansion expansionType) at Microsoft.AnalysisServices.Core.Server.Connect(String connectionString) at Microsoft.PowerBI.Client.Windows.RetryAction.Perform(Action func, Func`2 errorHandler, Int32 maxAttempts, Int32 checkIntervalMilliseconds) at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesService.ConnectServer(Object sender, EventArgs e) at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesProcess.Start() at System.Threading.Tasks.Task.Execute() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesService.<StartProcess>d__25.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 Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.PowerBI.Client.Windows.Utilities.AggregateExceptionHandlingExtensions.WaitAndUnpackException(Task task) at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesService.LoadDatabaseFromPbix(String filePath, Uri dataModelPath) at Microsoft.PowerBI.Client.Windows.Services.ReportFactory.CreateLocalDatabase(IPowerBIPackage powerBIPackage, String pbixFilePath, PowerBIPackageOpenOptions options, IAnalysisServicesService analysisServices) PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.107.841.0","ModuleName":"Microsoft.PowerBI.Amo.Core.dll","Component":"Microsoft.AnalysisServices.XmlaClient","Error":"Microsoft.AnalysisServices.ConnectionException","MethodDef":"OpenConnectionAndCheckIfSessionTokenNeeded","ErrorOffset":"134"} InnerException0.Stack Trace: at System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port) at Microsoft.AnalysisServices.XmlaClient.GetTcpClient(IConnectivityOwner owner, ConnectionInfo connectionInfo) OS Version: Microsoft Windows NT 10.0.19043.0 (x64 en-US) CLR Version: 4.8 or later [Release Number = 528372] Peak Virtual Memory: 53.6 GB Private Memory: 212 MB Peak Working Set: 373 MB IE Version: 11.789.19041.0   Workbook Package Info: None Telemetry Enabled: True DPI Scale: 125% Supported Services: Power BI ... View more

  Hello 1. Trying to join 2 tables on a field with in Table A which is duplicated to Table B which has no nulls or dupliates. Only wants to join many to many which is incorrect. 2. The same table when trying to create a visual with only fields from the table (join disabled at this point and not needed) When adding bigint field to the visual, produces error. Below:   Feedback Type: Frown (Error) Timestamp: 2022-08-08T13:11:07.2865401Z Local Time: 2022-08-08T13:11:07.2865401+00:00 Session ID: d3d3c72f-253d-4406-bda6-72492c2b478e Release: July 2022 Product Version: 2.107.841.0 (22.07) (x64) Error Message: OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression.. OS Version: Microsoft Windows NT 10.0.19044.0 (x64 en-US) CLR Version: 4.8 or later [Release Number = 528372] Peak Virtual Memory: 103 GB Private Memory: 775 MB Peak Working Set: 0.993 GB IE Version: 11.789.19041.0 User ID: 42982a8d-d99b-45bc-bd53-f58fcfeb88e3 Workbook Package Info: 1* - en-GB, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True. Telemetry Enabled: True Snapshot Trace Logs: C:\Users\pinnaca\Microsoft\Power BI Desktop Store App\FrownSnapShotab71e087-7481-47c2-a57b-e359c03abb45.zip Model Default Mode: DirectQuery Model Version: PowerBI_V3 Performance Trace Logs: C:\Users\pinnaca\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip Enabled Preview Features: PBI_mobileAuthoringFormattingUI PBI_sparklines Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_qnaLiveConnect PBI_azureMapVisual PBI_compositeModelsOverAS PBI_enhancedTooltips PBI_scorecardVisual PBI_fieldParametersSuperSwitch Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud DPI Scale: 100% Supported Services: Power BI Formulas: section Section1; shared stores = let Source = MariaDB.Contents("localhost:3306", "rdl_100"), stores_Table = Source{[Name="stores",Kind="Table"]}[Data] in stores_Table; ... View more

Oracle database with different schemas which uses individual or schema specific credentials.  In power bi service created schema specific gateway connections and created data flows with same oracle data source with schema specific credentials, When tried to map schema specific data connection to respective data flow, power bi is automatically selecting other gateway connection instead of selected one ... View more

Hi, A report I created two years ago fails to open in Power BI Desktop. I tried both the archived .pbix file and also downloading a report from Power BI service to .pbix and opening it. In both cases Power BI Desktop will not open a file - shows "failed to update the linguistic schema" error Details:     Feedback Type: Frown (Error) Timestamp: 2022-08-08T10:04:56.0625999Z Local Time: 2022-08-08T12:04:56.0625999+02:00 Session ID: d1118e7a-51b5-40e9-8d8d-764b68120a48 Release: March 2022 Product Version: 2.103.881.0 (22.03) (x64) Stack Trace: System.InvalidOperationException at Microsoft.PowerBI.Lucia.LinguisticSchemaContainer.EnsureSchema() at Microsoft.PowerBI.Lucia.LinguisticSchemaContainer.UpgradeIfNeeded(Func`1 getConceptualSchema, String defaultContent, Func`2 doAdditionalUpgrades) at Microsoft.PowerBI.Modeler.ModelManager.UpgradeLinguisticSchema() at Microsoft.PowerBI.Modeling.Engine.Authoring.SchemaChangeApplier.Apply(IModelManager modelManager, IEnumerable`1 changes, IRefreshPolicyUpdater refreshPolicyUpdater, IPrivateInformationService privateInformationService) at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.ModelAuthoringTransaction.ExecuteChange(ModelChange modelChange, Boolean saveChange, ISchemaChangeApplierFactory schemaChangeApplierFactory, IRefreshPolicyUpdater refreshPolicyUpdater, IPrivateInformationService piiService, String descriptionToTrace) at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.ExtendedModelChangeScope.ExecuteChange(ModelChange modelChange, Boolean saveChange, RecalcBehavior recalcBehavior, String descriptionToTrace) at Microsoft.PowerBI.Modeling.Engine.Upgrade.ModelUpgrader.RunPreV3UpgradesImpl(IExtendedModelChangeScope scope, ModelUpgradeResult upgradeResult, IDataModel dataModel, ModelingMashupDocument mashupDocument, String currentProductVersion) at Microsoft.PowerBI.Modeling.Engine.Upgrade.ModelUpgrader.<>c__DisplayClass8_0.<RunPreV3Upgrades>b__0() at Microsoft.PowerBI.Modeling.Engine.Upgrade.ModelUpgrader.ExecuteAndSaveOrCommit(IExtendedModelChangeScope modelChangeScope, Action actionToExecute, String description, Func`2 throwOnSaveOrCommitException) at Microsoft.PowerBI.Modeling.Engine.Upgrade.ModelUpgrader.UpgradeModel(IExtendedModelChangeScope modelChangeScope, IModelingSession modelingSession, ModelingSettings modelingSettings, ModelingMashupDocument modelingMashupDocument, String currentProductVersion, IEmbeddedValueUpgrader embeddedValueUpgrader, Boolean areV3UpgradeErrorsFatal, Boolean forceUpgrade) at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.ExtendedModelChangeScope.<>c__DisplayClass29_0.<UpgradeModel>b__0() at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<>c__DisplayClass6_0`1.<RunInActivity>b__0() at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.RunInActivity(ModelingActivityKind activity, Action action) at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.RunInActivity[T](ModelingActivityKind activity, Func`1 action) at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.DesktopModelingHost.<>c__DisplayClass18_0.<UpgradeModel>b__0(IExtendedModelChangeScope scope) at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.<>c__DisplayClass9_0.<RunExtendedModelChangeAsync>b__0(IExtendedModelChangeScope scope) at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.<>c__DisplayClass10_0.<<RunExtendedModelChangeAsync>b__0>d.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 Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.<ContinueWithAsyncOperation>d__13.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 Microsoft.PowerBI.Client.Windows.Modeling.Hosting.DesktopModelingHost.<RunOutOfBandExtendedModelChange>d__29.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 Microsoft.PowerBI.Client.Windows.Modeling.Hosting.DesktopModelingHost.<UpgradeModel>d__18.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 Microsoft.PowerBI.Client.Windows.ReportUpgrader.<Upgrade>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 Microsoft.PowerBI.Client.Windows.ReportPreparer.<UpgradeModel>d__16.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 Microsoft.PowerBI.Client.Windows.ReportPreparer.<Prepare>d__8.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 Microsoft.PowerBI.Client.Windows.Services.PowerBIPackagingService.<Open>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 Microsoft.PowerBI.Client.Windows.Services.FileManager.<LoadFromPbix>d__24.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 Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.<>c__DisplayClass13_0`1.<<BlockUIAndRun>b__0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.WaitOnUIThreadForTaskCompletion[T](Task`1 task) at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.BlockUIAndRun[T](Func`1 asyncMethod) at Microsoft.PowerBI.Client.Windows.Services.FileManager.OpenFile(IPowerBIWindowService windowService, IPbixFile fileToOpen, Nullable`1 entryPoint) at Microsoft.PowerBI.Client.Program.TryOpenOrCreateReport(IPowerBIWindowService windowService, IFileManager fileManager, IFileHistoryManager fileHistoryManager, String filePath, FileType fileType, IFileInformationProtectionManager fileInformationProtectionManager) at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_1.<Main>b__2() at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.103.881.0","ModuleName":"Microsoft.PowerBI.Lucia.Contracts.dll","Component":"Microsoft.PowerBI.Lucia.LinguisticSchemaContainer","Error":"System.InvalidOperationException","MethodDef":"EnsureSchema","ErrorOffset":"75"} OS Version: Microsoft Windows NT 10.0.22621.0 (x64 en-US) CLR Version: 4.7 or later [Release Number = 533320] Peak Virtual Memory: 53.9 GB Private Memory: 428 MB Peak Working Set: 566 MB IE Version: 11.1.22621.0 User ID: 2fc18f18-9130-4740-a46e-72e72e61ab37 Telemetry Enabled: True DPI Scale: 200% Supported Services: Power BI ... View more

As you can see on the screenshot below all my Dataflows refreshed unsuccessfully in the morning. It happened at 6:45 AM. But I have NOT scheduled refreshing my Dataflow for that time. F.e. below are settings for one of my Dataflows. As you can see my real scheduled time is 12:00 PM     ... View more

Admin - Datasets GetDatasetUsersAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Docs There is a limit to 200 requests per hour. This API looks at each end point item (reports, dashboards, datasets, datamarts etc), i believe, and resolves the users/permissions for each associated dataset being consumed by the end point. This is extremely valuable for dataset,report and workspace permissions and licensing management across the tenancy. Unfortunately the 200 per hour means it is not a viable option, currently, for anything but small tenancies. We can get the resolved users from each endpoint independently via specific API GetXXUsersAsAdmin. The DatasetUsers API  does not have a feature to get only direct Dataset assigned users (dataset access shared with user). Its all or nothing. Im asking for an enhancement to the REST API to increase the number of calls allowed (unlimeted would be ideal!!) and/or to be able to limit/identify the source of the user permission on the dataset. Similar to the "GET https://api.powerbi.com/v1.0/myorg/admin/groups/{groupId}?$expand={$expand}" - Get Groups as Admin with an expand or filter option for specific end points This would give the flexibility to get a whole of tenancy dataset usership via the API. Note: The APIs for workspace info, while comprehensive, dont lend themselves to automation of tenant wide data. https://docs.microsoft.com/en-us/rest/api/power-bi/admin/workspace-info-post-workspace-info https://docs.microsoft.com/en-us/rest/api/power-bi/admin/workspace-info-get-scan-result   ... View more