Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Open PBIX crashes when connecting to PBI Service Dataset in different tenant

We have different AAD tenants that use PowerBI (e.g. different subsidiaries). When, in PowerBI Desktop, I am logged in with a user from Tenant A and I open a file that connects to a dataset hosted in Tenant B, I get the error "Sequence contains no matching element"

I would expect to be able to change the connecton to a dataset in the current tenant OR the option to login with a different user. Right now I cannot do anything except logging in with a user from the correct tenant first before opening the report (but I do not always know where the file connects to!)

 

kind regards,

-gerhard

 

here are the details of the error:

Feedback Type:
Frown (Error)

Error Message:
Sequence contains no matching element

Stack Trace:
at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
at System.Windows.Forms.WindowsFormsSynchronizationContext.Send(SendOrPostCallback d, Object state)
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.AllowModalDialogs(Action action)
at Microsoft.PowerBI.Client.Windows.LiveConnectHelpers.LiveConnectionPropertiesValidator.TryGetValidLiveConnectionProperties(IPowerBIWindowService windowService, ILiveConnectionProperties connectionProperties, ILiveConnectionProperties& validLiveConnectionProperties, Boolean& resultIsSameConnection)
at Microsoft.PowerBI.Client.Windows.ReportPreparer.EnsureValidLiveConnectionProperties(Report report, IPowerBIWindowService windowService)
at Microsoft.PowerBI.Client.Windows.ReportPreparer.Prepare(Report report, PackageValidationResult mashupResult, IPowerBIWindowService windowService, Nullable`1 entryPoint)
at Microsoft.PowerBI.Client.Windows.Services.PowerBIPackagingService.Open(FileStream fileStream, IPowerBIWindowService windowService, Nullable`1 entryPoint, PowerBIPackageOpenOptions options, Boolean& allCredentialsSatisfied)
at Microsoft.PowerBI.Client.Windows.Services.FileManager.<LoadFromPbix>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.UIBlockingService.<>c__DisplayClassa`1.<<BlockUIAndRun>b__9>d__c.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(Task 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.Windows.Services.FileOperationUIHandler.OpenFileInternal(IPowerBIWindowService windowService, IQueryServices queryServices, TelemetryUserActionId entryPoint, IPbixFile pbixFile, Boolean allowAsExcelImport, Boolean fromRecentFile)
at Microsoft.PowerBI.Client.Windows.Services.FileOperationUIHandler.OpenLocalFile(IPowerBIWindowService windowService, IQueryServices queryServices, TelemetryUserActionId entryPoint, String filePath, Boolean fromRecentFile)
at Microsoft.PowerBI.Client.Windows.MainWindow.OpenDocument(TelemetryUserActionId entryPoint, String testFilePath)
at Microsoft.Mashup.Client.UI.Shared.UICommands.CommandActionHandlerBase.CommandAction(UInt32 commandId)
at Microsoft.Mashup.Client.UI.Windows.Ribbon.RibbonCommandHandler.Execute(UInt32 commandId, CommandExecutionVerb verb, PropertyKeyRef keyRef, PropVariantRef currentValue, IUISimplePropertySet commandExecutionProperties)

Stack Trace Message:
Sequence contains no matching element

Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.PowerBI.Client.Windows.Utilities.UIBlockingAwareExceptionHandler.HandleException(Exception e)
at Microsoft.Mashup.Client.UI.Windows.Ribbon.RibbonCommandHandler.Execute(UInt32 commandId, CommandExecutionVerb verb, PropertyKeyRef keyRef, PropVariantRef currentValue, IUISimplePropertySet commandExecutionProperties)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__FabricatedMethod8(IWindowHandle )
at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass10.<Main>b__0()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass7.<HandleExceptionsWithNestedTasks>b__6()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.Main(String[] args)


Model Default Mode:
Empty

Snapshot Trace Logs:
C:\Users\gbrueckl\Microsoft\Power BI Desktop Store App\FrownSnapShot2114985722.zip

Performance Trace Logs:
C:\Users\gbrueckl\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_newFromWeb
PBI_SpanishLinguisticsEnabled
CustomConnectors
PBI_variationUIChange
PBI_canvasTooltips
PBI_PythonSupportEnabled
PBI_showIncrementalRefreshPolicy
PBI_compositeModels
PBI_DB2DQ

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

Formulas:


section Section1;

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @gbrueckl,

 

Which Power BI desktop version do you run?

 

Based on my test with the latest Power BI desktop version 2.61.5192.601 64-bit (August 2018), if we already signed in Power BI desktop with tenant A account, when we open the pbix file which connects to tenant B dataset (signed in account doesn't have permission), there is a Edit button for us to select the datasets resides in tenant A account Power BI service. 

 

q1.PNG

 

I would suggest you update your Power BI desktop version 2.61.5192.601 then test again. 

 

Best Regards,
Qiuyun Yu 

gbrueckl
Most Valuable Professional

I am using the Windows Store App for Power BI Desktop so it automatically updates to the latest version. I am also running on Version: 2.61.5192.601 64-bit (August 2018)

 

to reproduce the issue:

1) Open PBI Desktop and login with a user from tenant A (gerhard@myFirstTenant.com)

2) connect to a dataset in the Power BI Service of "myFirstTenant"

3) save the file as "myFirstTenant.pbix"

4) Sign out of PowerBI

5) Close PowerBI

6) Open PowerBI again

7) Sign in with a user from tenant B (gerhard@mySecondTenant.com)

😎 Open the file "myFirstTenant.pbix"

9) error appears

 

The dialog fom your screenshot never shows up 

 

v-qiuyu-msft
Community Support

Hi @gbrueckl,

 

I tested with Microsoft Store Power BI desktop version, unfortunately didn't reproduce the issue. The Power BI BI desktop version is updated to 2.62.5222.403 64-bit (September 2018) automatically on my side, I would suggest you check if it's updated on your side as well and test again. 

 

Best Regards,
Qiuyun Yu 

gbrueckl
Most Valuable Professional

It seems that in my region (Austria) the September update is not yet rolled out. I still see August 2018 verseion even after uninstalling and installing again from the Windows Store