Unable to get data connection to PowerBi

[ashinde_TYL (Abhishek Shinde @ TYLin)]

Hello,
Specklers,

I am trying to create a dashboard with PowerBi using https://app.speckle.systems URL and I get the following error. I have set the Project as Link Shareable and anyone can comment. Could you please help me

Thank you so much

Best
Abhishek

[jonathon]

Welcome back @ashinde_TYL

Take a look at my answer here:

PowerBI connector not loading data

It seems to be a PowerBI issue due to how it stores (and sometimes loses) credentials. The guidance I have found is to clear permissions for the Speckle data source you are using (perhaps app. sickle.systems) and re-authenticate. Open Power BI Desktop, when you already created visuals use the existing pbix go to File → Options and settings → Data source settings Check “Data sources in current file” and “Global permissions”, mark any source that points to the new Speckle server and hit “Clea…

[ashinde_TYL (Abhishek Shinde @ TYLin)]

Thanks Jonathon for pointing me at the right direction. I followed the steps and it worked. Secondly when prompted for sign in i used my personal token to sign into PowerBi connector. Appreciate this a lot.

[Dave_O (Dave Otis)]

Hi @jonathon !
I follow the step but Im facing this error when I’m trying to re-authenticate:

[jonathon]

Is this with the latest version of the Powerbi connector?

[Dave_O (Dave Otis)]

Yes, fresh from this morning

[Dave_O (Dave Otis)]

The error detail:

Feedback Type:
Frown (Error)

Timestamp:
2025-03-13T15:59:25.7583293Z

Local Time:
2025-03-13T11:59:25.7583293-04:00

Session ID:
01c27080-2e5d-48d1-a987-5fd8a9ef7582

Release:
February 2025

Product Version:
2.140.1476.0 (25.02)+e8c6a85d1d09735c5c055c3244a60ff4076cd2cf (x64)

Error Message:
Value cannot be null.
Parameter name: uriString

Stack Trace:
System.ArgumentNullException
   at System.Uri..ctor(String uriString, UriKind uriKind)
   at System.UriBuilder..ctor(String uri)
   at Microsoft.Mashup.Client.UI.Extensions.Windows.SystemBrowserOAuthDialog.WrapUrlForPowerBiOAuthRedirect(Uri authorizationUri, UriBuilder redirectUriBuilder)
   at Microsoft.Mashup.Client.UI.Extensions.Windows.SystemBrowserOAuthDialog.Authorize(Uri logoutUri, Uri authorizationUri)
   at Microsoft.Mashup.Client.UI.Shared.OAuthManager.<OpenOAuthDialog>d__11.MoveNext()

Stack Trace Message:
Value cannot be null.
Parameter name: uriString

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__DisplayClass14_0.<HandleException>b__0()
   at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
   at Microsoft.Mashup.Client.UI.Shared.OAuthManager.<OpenOAuthDialog>d__11.MoveNext()
   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)
   at Microsoft.Mashup.Client.UI.Shared.OAuthManager.OpenOAuthDialog(IWindowHandle parentWindowHandle, ITelemetryService telemetryService, String resourceKind, String accessToken, String resourceUrl)
   at Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.ChallengeFloatingDialogBase.<OpenOAuthDialogAsync>d__29.MoveNext()
   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
   at Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.ChallengeFloatingDialogBase.OpenOAuthDialogAsync(IDialog parentDialog, ILegacyUIHost uiHost, IExceptionHandler exceptionHandler, IJsHostedScript jsHostedScript, IInteractiveMsalProvider msalProvider, ITelemetryService telemetryService, String resourceKind, String logoutAccessToken, String dataUrl)
   at Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.ChallengeFloatingDialogBase.OnOpenOAuthDialog(String resourceKind, String logoutAccessToken, String dataUrl)
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at Microsoft.Mashup.Client.UI.Shared.JsExportWrapper.<>c__DisplayClass13_0.<InvokeMember>b__0()
   at Microsoft.Mashup.Client.UI.Windows.JsErrorHandler.WrapInvokeHost(Func`1 invokeHost)
   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.Windows.DialogWindowBase.ShowModal(IWindowHandle windowHandle)
   at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
   at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
   at Microsoft.Mashup.Client.UI.Shared.Ux.CredentialsChallengeResolver.ShowResolveDialog(IWindowHandle owner, IUIHost uiHost)
   at Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.BuilderDialog.Js_HandleCredentialChallengeAndCloseBuilder(String dialogData)
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at Microsoft.Mashup.Client.UI.Shared.JsExportWrapper.<>c__DisplayClass13_0.<InvokeMember>b__0()
   at Microsoft.Mashup.Client.UI.Windows.JsErrorHandler.WrapInvokeHost(Func`1 invokeHost)
   at System.Windows.Forms.UnsafeNativeMethods.IDispatch.Invoke(Int32 dispIdMember, Guid& riid, Int32 lcid, Int32 dwFlags, tagDISPPARAMS pDispParams, Object[] pVarResult, tagEXCEPINFO pExcepInfo, IntPtr[] pArgErr)
   at System.Windows.Forms.UnsafeNativeMethods.IDispatch.Invoke(Int32 dispIdMember, Guid& riid, Int32 lcid, Int32 dwFlags, tagDISPPARAMS pDispParams, Object[] pVarResult, tagEXCEPINFO pExcepInfo, IntPtr[] pArgErr)
   at System.Windows.Forms.HtmlDocument.InvokeScript(String scriptName, Object[] args)
   at Microsoft.Mashup.Client.UI.Windows.JsErrorHandler.WrapInvokeScript(Func`1 invokeScript)
   at Microsoft.Mashup.Client.UI.Shared.AjaxHost.AjaxHandler.<>c__DisplayClass11_0.<OnProcessAjaxAsync>b__0()
   at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass2_0.<SendAndMarshalExceptions>b__0(Object null)
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Delegate.DynamicInvokeImpl(Object[] args)
   at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
   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.Windows.DialogWindowBase.ShowModal(IWindowHandle windowHandle)
   at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
   at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
   at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
   at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModalWithInitialReentrancyLock(FloatingDialog floatingDialog, ILegacyUIHost uiHost, Func`1 showModalFunction)
   at Microsoft.Mashup.Client.UI.Shared.DataImporter.ShowBuilderDialog(PackageReference packageReference, FormulaPath formulaPath, FormulaPartInfo formulaPartInfo, Query query, Action`2 successCallback, Action failureCallback, Boolean isNewQuery, Boolean isFromEditor)
   at Microsoft.Mashup.Client.UI.Shared.DataImporter.ResolveQuerySettings(Query query, Action`2 successCallback, Action failureCallback, ResolutionSetting resolutionSetting, Boolean isNewQuery, Boolean isFromEditor)
   at Microsoft.Mashup.Client.UI.Shared.DataImporter.ResolveQuerySettings(Query query, SourceFormula addedFormula, Boolean isNewQuery, Boolean isFromEditor)
   at Microsoft.Mashup.Client.UI.Shared.DataImporter.TryAddSource(String sourceID, Nullable`1 targetQueryGroupId, Query& newQuery)
   at Microsoft.PowerBI.Client.Windows.PowerBIDataImporter.TryAddSource(String sourceID, Nullable`1 targetQueryGroupId, Query& newQuery)
   at Microsoft.Mashup.Client.UI.Shared.ConnectHelper.Connect(IWindowHandle owner, IDataSourceTemplateProvider dataSourceTemplateProvider, ILegacyUIHost uiHost, ITelemetryService telemetryService, DataImporter dataImporter, CommandUIControlBase commandUIControl, String sourceId, Nullable`1 targetQueryGroupId)
   at Microsoft.PowerBI.Client.Windows.Services.QueriesEditorWindowManager.GetData(PowerBIDataImporter dataImporter, String sourceId, Nullable`1 targetQueryGroupId, IDataSourceTemplateProvider dataSourceTemplateProvider, IWindowHandle ownerWindow)
   at Microsoft.PowerBI.Client.Windows.Commands.ApplicationCommands.DataImportCommands.<Connect>d__52.MoveNext()
   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
   at Microsoft.PowerBI.Client.Windows.Commands.ApplicationCommands.DataImportCommands.Connect(IPowerBIWindowService windowService, IExceptionHandler exceptionHandler, ConnectParameters parameters)
   at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()
   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
   at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAwaitableAsyncExceptions(IExceptionHandler exceptionHandler, Func`1 asyncFunc)
   at Microsoft.PowerBI.Client.Windows.Commands.CompositeCommand`1.Execute(ICommand command, Object parameter)
   at Microsoft.Practices.Prism.Commands.CompositeCommand.Execute(Object parameter)
   at Microsoft.PowerBI.Client.Windows.Commands.CompositeCommand`1.Execute(T parameter)
   at Microsoft.PowerBI.Client.Windows.PowerBIDataSourceTemplateProvider.ConnectInternal(String formulaId, Nullable`1 targetQueryGroupId)
   at Microsoft.Mashup.Host.Document.DataSourceTemplateProvider.Connect(String formulaId, Nullable`1 targetQueryGroupId)
   at Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.SimpleDialog.DataSourceGalleryDialog.<>c__DisplayClass12_0.<ConnectToDataSource>b__0()
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Delegate.DynamicInvokeImpl(Object[] args)
   at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
   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.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
   at Microsoft.PowerBI.Client.AppModule.<>c__DisplayClass4_0.<Run>b__0()
   at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   at Microsoft.PowerBI.Client.AppModule.Run()
   at Microsoft.PowerBI.Client.Program.RunApplicationFlow(String[] args, IPowerBIRootTrace trace)
   at Microsoft.PowerBI.Client.Program.Main(String[] args)


PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.140.1476.0","ModuleName":"Microsoft.Mashup.Client.UI.Extension.dll","Component":"Microsoft.Mashup.Client.UI.Extensions.Windows.SystemBrowserOAuthDialog","Error":"System.ArgumentNullException","MethodDef":"WrapUrlForPowerBiOAuthRedirect","ErrorOffset":"26","ErrorCode":""}

OS Version:
Microsoft Windows NT 10.0.26100.0 (x64 en-GB)

CLR Version:
4.8 or later [Release Number = 533320]

Peak Virtual Memory:
71.7 GB

Private Memory:
1.03 GB

Peak Working Set:
1.32 GB

IE Version:
11.1882.26100.0

User ID:
b98033c5-8a2f-4cac-aee6-045fce9b7bde

Workbook Package Info:
1* - en-CA, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False.

Telemetry Enabled:
True

Snapshot Trace Logs:
C:\Users\dave.otis\Microsoft\Power BI Desktop Store App\FrownSnapShotbcea4d1e-debc-4cc7-a9fb-ab4af589c24f.zip

Model Default Mode:
Empty

Model Version:
PowerBI_V3

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

Enabled Preview Features:
PBI_sparklines
PBI_scorecardVisual
PBI_fieldParametersSuperSwitch
PBI_setLabelOnExportPdf
PBI_oneDriveSave
PBI_oneDriveShare
PBI_useModernPublishDialogs
PBI_gitIntegration
PBI_tmdlInDataset
PBI_directLakeRemoteModeling
PBI_newCard
PBI_buttonSlicerAuthoring
PBI_EimLessElevatedUser
PBI_mobileAutoReportLayout
PBI_daxInlineCopilot
PBI_aiNarrativesVisual
PBI_generateMeasureDescriptionsButton
PBI_visualCalculationsAuthoring
PBI_desktopReportAuthoringCopilot

Disabled Preview Features:
PBI_snowflakeAdbcVersionEnabled
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_metricsArtifactsOnDesktop
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_onObject
PBI_odspSaveBackgroundUpload
PBI_modernOfficeFilePicker
PBI_publishDialogsSupportSubfolders
PBI_enhancedReportFormat
PBI_advancedSlicerTypeList
PBI_textSlicer
PBI_qnaImproveLsdlCopilot
PBI_tmdlViewToggle
PBI_UserInstalledVerticaODBCDriver

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

PowerBIUserFeedbackServices_IsReported:
True

DPI Scale:
125%

Supported Services:
Power BI

Formulas:


section Section1;

shared Query1 = let
    Source = Speckle.GetByUrl("https://app.speckle.systems/projects/10998ad4ad/models/19585f4f58")
in
    Source;

[Trung535 (Hoang Duc Trung)]

Can you resolve this problem? If you can, please help me. Thank you so much

[Dave_O (Dave Otis)]

@Trung535 , i don’t know if you ask me the question but i’m still have the problem.
@jonathon it’s the same problem that @ashinde_TYL faced but when i’m looking at her screenshot, it’s not the new version of the visual. I don’t know about is connector.