Token '=' expected. Start position: (1,29). End position (1.32) when refreshing my report

[KoenM]

Feedback Type:
Frown (Error)

Timestamp:
2024-09-18T09:55:44.6601199Z

Local Time:
2024-09-18T11:55:44.6601199+02:00

Session ID:
39f8cd6a-732d-4f0a-bd94-c964161f17d6

Release:
October 2024

Product Version:
2.134.7447.1 (Main) (x64)

Stack Trace:
Microsoft.Data.Mashup.MashupExpressionException
at Microsoft.Data.Mashup.Util.ThrowParseError(IError error)
at Microsoft.Mashup.Engine1.Engine.ParseMany(ITokens tokens, IDocumentHost host, Action`1 log)
at Microsoft.Data.Mashup.Util.ParseSectionDocuments(IEngine engine, String text)
at Microsoft.Data.Mashup.MashupPackage.GetDocuments(String package, String mashup)
at Microsoft.Data.Mashup.MashupConnection.FindReferencedDataSources(MashupDiscoveryOptions options, MashupPartitionCoordinateType coordinateType)
at Microsoft.PowerBI.Client.Windows.OriginalTableExtractor.GetOriginalTableExpression(String mExpression, IReadOnlyDictionary`2 referencedParameterQueryFormulaTextMap)
at Microsoft.PowerBI.Client.Windows.MashupQueryExecutorFactory.GetQueryAttributes(Report report, IEnumerable`1 queriesToEvaluate)
at Microsoft.PowerBI.Client.Windows.MashupQueryExecutorFactory.CreateMashupQueryExecutor(Report report, IEnumerable`1 queriesToEvaluate)
at Microsoft.PowerBI.Client.Windows.AnalysisServices.QueryEvaluator.LoadToModelQueryEvaluator.EvaluateForLoadAsync(IEnumerable`1 queriesToEvaluate, ISet`1 queriesToEvaluateForFoldability, IProgress`1 progress, CancellationToken cancellationToken, Boolean evaluateUndefinedStorageModeAsDirectQuery)
at Microsoft.PowerBI.Client.Windows.AnalysisServices.LoadToModelQueryEvaluationService.<EvaluateForLoadAsync>d__4.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.ModelingTelemetryService.<>c__DisplayClass11_0`1.<<RunInAsyncActivity>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.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<RunInAsyncActivity>d__10.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.ModelingTelemetryService.<RunInAsyncActivity>d__11`1.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.Loader.LoadToReportFlow.<EvaluateQueries>d__12.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.Loader.LoadToReportFlow.<ExecuteInternal>d__10.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.Loader.LoadToReportFlow.<Execute>d__9.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.ModelingTelemetryService.<>c__DisplayClass11_0`1.<<RunInAsyncActivity>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.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<RunInAsyncActivity>d__10.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.ModelingTelemetryService.<RunInAsyncActivity>d__11`1.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.<>c__DisplayClass18_0.<<LoadToModel>b__1>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.<>c__DisplayClass9_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__12.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.<LoadToModel>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.FloatingDialog.KoLoadToReportDialog.<>c__DisplayClass43_0.<<StartLoadToReportFlow>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.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()

Error Code:
-2147467259 (0x80004005)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.134.7447.1","ModuleName":"Microsoft.Data.Mashup.dll","Component":"Microsoft.Data.Mashup.Util","Error":"Microsoft.Data.Mashup.MashupExpressionException","MethodDef":"ThrowParseError","ErrorOffset":"64","ErrorCode":""}

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

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

Peak Virtual Memory:
71.9 GB

Private Memory:
1.08 GB

Peak Working Set:
1.64 GB

IE Version:
11.1.22621.0

User ID:
92650537-261f-419d-b9ae-295d41589b1b

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

Telemetry Enabled:
True

Model Default Mode:
Import

Model Version:
PowerBI_V3

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

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_onObject
PBI_odspSaveBackgroundUpload
PBI_publishDialogsSupportSubfolders
PBI_tmdlInDataset
PBI_enhancedReportFormat
PBI_directLakeRemoteModeling
PBI_qnaImproveLsdlCopilot

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
125%

Supported Services:
Power BI

[v-yetao1-msft]

Hi @KoenM 

Where are you refreshing the report to get this error? Was this report refreshing properly before? Did you do any updates in the meantime?

Best Regards,
Community Support Team _ Ailsa Tao

[KoenM]

I was refreshing the report in Powerbi desktop (october 2024 version which I didn't ask for).

In the previous version it refreshed perfectly.

In the meantime I uninstalled the october version and reinstalled the august version and now it's working just fine

[v-yetao1-msft]

Hi @KoenM 

Microsoft Store had previously uploaded the wrong version, so that caused some problems. PG has now uploaded the correct version, and some of the issues with Desktop will be fixed as soon as the update is available. I'm glad that your issue is resolved.

Best Regards,
Community Support Team _ Ailsa Tao

[tuurankukka]

I'm having the same issue: can't refresh any of my reports with the latest version of Power BI Desktop.

Is there any updates on this from Microsoft side?

[KoenM]

According to @v-yetao1-msft they should have uploaded a new and corrected version. I just reinstalled an older version and didn't update yet. 

[yogesht194]

Hi,

I started getting this error since an hour ago. I am using Power BI Desktop version: 2.136.1202.0 64-bit (September, 2024)

Error message (View all messages) Token '=' expected. Start position: (1, 36). End position (1, 39).

I tried reinstalling the desktop version but no luck

Where can I get the earlier version? I tried but all the sites/blogs are redirecting to the latest version

Thanks,

[aguuzdo]

Hi, I'm getting the same error. I've got my PowerBI desktop updted today and I'm not being able to update my dashboards.

Does anyone have a solution for this?

[yogesht194]

Download all the previous versions of Power BI Desktop - 

Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn

I restored to the Aug 2024 version and was able to refresh the reports

[KoenM]

this is the august version I installed which got rid of all the errors:

32 bit:

https://download.microsoft.com/download/8/8/0/880BCA75-79DD-466A-927D-1ABF1F5454B0/PBIDesktopSetup-2...

64 bit:

https://download.microsoft.com/download/8/8/0/880BCA75-79DD-466A-927D-1ABF1F5454B0/PBIDesktopSetup-2...

Even older versions can be found here (keep scrolling down):

https://learn.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive?tabs=powerbi-d...

[saschafiebig]

Same issue, just got the new Desktop Version (2.136.1202.0) installed from the Microsoft Store. I was so happy about the dark mode, but that happiness disappeared pretty fast...
However some reports work and I only receive this error refreshing reports that use custom themes.