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

[gbrueckl]

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;

[v-qiuyu-msft]

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. 

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

Best Regards,
Qiuyun Yu 

[gbrueckl]

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]

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]

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