avatar user

BigQuery connection error

Submitted by Anonymous on ‎09-27-2023 07:57 AM

Hi,
I'm having issues getting BigQuery settings to appear when I set up a new connection.  I can select bigquery and try to connect, but then an error pops up with the details below.  Others on my team can connect but I specifically have issues.  I have uninstalled and tried reinstalling/restarting/etc.  Not sure where to go from here.

 

Thanks,

 

Feedback Type:
Frown (Error)

Timestamp:
2023-09-27T14:53:03.3407218Z

Local Time:
2023-09-27T10:53:03.3407218-04:00

Session ID:
3b9fe215-79a1-49e1-baf2-90ccbac3e433

Release:
September 2023

Product Version:
2.121.942.0 (23.09) (x64)

Stack Trace:
Microsoft.Mashup.Client.UI.Shared.ExceptionResultException
at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_TableSource()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_TableSource()
at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.121.942.0","ModuleName":"","Component":"Microsoft.Mashup.Evaluator.EvaluationHost","Error":"Microsoft.Mashup.Client.UI.Shared.ExceptionResultException","MethodDef":"OnException","ErrorOffset":"","ErrorCode":""}

OS Version:
Microsoft Windows NT 10.0.19045.0 (x64 en-US)

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

Peak Virtual Memory:
70.3 GB

Private Memory:
567 MB

Peak Working Set:
1.11 GB

IE Version:
11.789.19041.0

User ID:
37ed970b-39f3-45ce-821f-e2141b9ef202

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

Telemetry Enabled:
True

Model Default Mode:
Empty

Model Version:
PowerBI_V1

Enabled Preview Features:
PBI_sparklines
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_setLabelOnExportPdf
PBI_dynamicFormatString
PBI_newCard

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_angularRls
PBI_onObject
PBI_oneDriveSave
PBI_oneDriveShare
PBI_gitIntegration

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Investigating
See more ideas labeled with:
1 Comment (1 New)
Comments
avatar user
Anonymous
Not applicable
‎09-28-2023 01:42 AM

Hi  @Anonymous ,

 

Here are a few steps you can take to troubleshoot the issue:

 

Check your roles and permissions: To manage connections in BigQuery, you need certain roles and permissions. For example, to view connection details and list all connections, you need the BigQuery Connection User role on your dataset. To share, edit, or delete a connection, you need the BigQuery Connection Admin role on your connection.

Check the status of the BigQuery Connection API: Make sure that the BigQuery Connection API is enabled1.

Verify the service account: BigQuery creates and uses a service account to connect to your external data source. When you create a connection, a Google Cloud–managed Identity and Access Management (IAM) service account is created on your behalf.

 

 

Best regards.
Community Support Team_Caitlyn

 

Idea Statuses