Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowGet certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started
I have several datasets (datamodel only pbix reports) that I can no longer update by publishing from Power BI Desktop. I get the error : "We cannot convert the value "" to type Record". This does not affect all datasets, though I have not yet been able to determine what is causing the issue. Refreshing the datasets in Power BI Desktop is OK. Surprisingly, attempts to republish the same report to a different workspace returns the same error. Another finding: when I attempt to use Tabular editor to connect to the dataset in the Power BI Service, I also get this same error (was OK a week ago). Reverting to the May version of Power BI Desktop does not resolve the pb either.
I am stuck !
---------------------------
DataGridView Default Error Dialog
---------------------------
The following exception occurred in the DataGridView:
System.Reflection.TargetInvocationException: Property accessor 'CompatibilityLevel' on object 'Microsoft.AnalysisServices.Tabular.Database' threw the following exception:'COM error: Microsoft.MashupEngine, [Expression.Error] We cannot convert the value "" to type Record..
Technical Details:
RootActivityId: d3cc70a8-0cdf-4e07-9de1-df5f3a25898d
Date (UTC): 7/1/2020 8:51:01 AM
' ---> Microsoft.AnalysisServices.OperationException: COM error: Microsoft.MashupEngine, [Expression.Error] We cannot convert the value "" to type Record..
Technical Details:
RootActivityId: d3cc70a8-0cdf-4e07-9de1-df5f3a25898d
Date (UTC): 7/1/2020 8:51:01 AM
at Microsoft.AnalysisServices.XmlaClient.CheckForSoapFault(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)
at Microsoft.AnalysisServices.XmlaClient.CheckForError(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)
at Microsoft.AnalysisServices.XmlaClient.SendMessage(Boolean endReceivalIfException, Boolean readSession, Boolean readNamespaceCompatibility)
at Microsoft.AnalysisServices.Core.AnalysisServicesClient.Discover(IMajorObject obj, ObjectExpansion expansion, JaXmlSerializer serializer)
at Microsoft.AnalysisServices.Core.Server.Refresh(IMajorObject obj, ObjectExpansion expansion)
at Microsoft.AnalysisServices.Core.Server.SendRefresh(IMajorObject obj, ObjectExpansion expansion)
at Microsoft.AnalysisServices.MajorObject.Refresh()
at Microsoft.AnalysisServices.MajorObject.get_Body()
at Microsoft.AnalysisServices.Core.Database.get_CompatibilityLevel()
--- End of inner exception stack trace ---
at System.ComponentModel.ReflectPropertyDescriptor.GetValue(Object component)
at System.Windows.Forms.DataGridView.DataGridViewDataConnection.GetValue(Int32 boundColumnIndex, Int32 columnIndex, Int32 rowIndex)
To replace this default dialog please handle the DataError event.
---------------------------
OK
---------------------------
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.