After updating desktop from June 2019 to November 2019 cannot connect to Cube

[kakkaroolari]

BACKGROUND:

I have a tabular model deployed to SSAS

WHEN

I click Get Data -> SSAS

THEN

I see error message "Unique constraint not found"

This was working in Desktop June 2019

What do I need to fix?

How can I see any detailed error messages? Is that possible?

[v-diye-msft]

Hi @kakkaroolari 

Sorry I can't repro your issue on my side.

You can enable the below option and check the log:

If you 'd like to reinstall the old version, you might refer to :

https://winaero.com/blog/restore-previous-versions-windows-10/ 

[kakkaroolari]

Ok, managed to get log traces.

What then do I need to find in the logs?

full log: https://www.dropbox.com/s/q5vytte66ejgwge/PBIDesktop.17392.2019-12-04T08-02-42-833151.log?dl=0

I see internal exceptions on powerbi desktop, but no clue on how to fix the issue still.

One exception is: Microsoft.Mashup.Host.Document.Analysis.IncompleteFormulaAnalysisException

$ grep ^DataMashup.Trace.Warning.* PBIDesktop.17392.2019-12-04T08-02-42-833151.log

DataMashup.Trace Warning: 24579 : {"Start":"2019-12-04T08:02:44.5585563Z","Action":"PBI.CommandExecute","commandName":"ConnectCommand","parentId":"parentId","isError":"False","sessionId":"1828244b-f63b-4c8d-8f71-837c6fc4e93f","deviceId":"9b6f6448","userId":"ca9fecbc-d1fe-43a5-b110-82cc6c30cd83","isInternal":"False","authenticatedUserId":"877887d3-d734-4c29-b937-6381ed62257f","ProductVersion":"2.75.5649.961 (19.11)","ActivityId":"40ce6a99-90a8-4b96-ba02-c602f3b0a6f8","Process":"PBIDesktop","Pid":17392,"Tid":1,"Duration":"00:00:00.0003977"}
DataMashup.Trace Warning: 24579 : {"Start":"2019-12-04T08:02:46.5013283Z","Action":"DataSourceGalleryDialogShown","dialogInstanceId":"efe38fe0-3d12-4bf7-b23d-4bc7d739feb2","sessionId":"1828244b-f63b-4c8d-8f71-837c6fc4e93f","deviceId":"9b6f6448","userId":"ca9fecbc-d1fe-43a5-b110-82cc6c30cd83","isInternal":"False","authenticatedUserId":"877887d3-d734-4c29-b937-6381ed62257f","ProductVersion":"2.75.5649.961 (19.11)","ActivityId":"3d6e80c9-62b2-486b-bd29-74496d504fff","Process":"PBIDesktop","Pid":17392,"Tid":1,"Duration":"00:00:00.0002867"}
DataMashup.Trace Warning: 24579 : {"Start":"2019-12-04T08:03:16.2646633Z","Action":"DataSourceGalleryDialogCommitted","dialogInstanceId":"efe38fe0-3d12-4bf7-b23d-4bc7d739feb2","sessionId":"1828244b-f63b-4c8d-8f71-837c6fc4e93f","deviceId":"9b6f6448","userId":"ca9fecbc-d1fe-43a5-b110-82cc6c30cd83","isInternal":"False","authenticatedUserId":"877887d3-d734-4c29-b937-6381ed62257f","ProductVersion":"2.75.5649.961 (19.11)","ActivityId":"9e359874-7981-4067-b8aa-3395ba682321","Process":"PBIDesktop","Pid":17392,"Tid":1,"Duration":"-00:00:00.0000568"}
DataMashup.Trace Warning: 24579 : {"Start":"2019-12-04T08:03:16.2656450Z","Action":"DataSourceGalleryDialogConnecting","dialogInstanceId":"efe38fe0-3d12-4bf7-b23d-4bc7d739feb2","sourceFormulaId":"formulaAnalysisServicesDatabases","sessionId":"1828244b-f63b-4c8d-8f71-837c6fc4e93f","deviceId":"9b6f6448","userId":"ca9fecbc-d1fe-43a5-b110-82cc6c30cd83","isInternal":"False","authenticatedUserId":"877887d3-d734-4c29-b937-6381ed62257f","ProductVersion":"2.75.5649.961 (19.11)","ActivityId":"f9a208c1-6081-40b4-bff9-5c92179fb346","Process":"PBIDesktop","Pid":17392,"Tid":1,"Duration":"00:00:00.0007693"}
DataMashup.Trace Warning: 24579 : {"Start":"2019-12-04T08:03:16.2666580Z","Action":"PBI.PQ.GetData","message":"","actionId":"DataSourceGalleryFromAnalysisServices","sessionId":"1828244b-f63b-4c8d-8f71-837c6fc4e93f","deviceId":"9b6f6448","userId":"ca9fecbc-d1fe-43a5-b110-82cc6c30cd83","isInternal":"False","authenticatedUserId":"877887d3-d734-4c29-b937-6381ed62257f","ProductVersion":"2.75.5649.961 (19.11)","ActivityId":"29d9c01f-c8d3-4536-8043-effdd125c646","Process":"PBIDesktop","Pid":17392,"Tid":1,"Duration":"-00:00:00.0001275"}
DataMashup.Trace Warning: 24579 : {"Start":"2019-12-04T08:03:16.4481479Z","Action":"PBI.CommandExecute","commandName":"ConnectCommand","parentId":"parentId","isError":"False","sessionId":"1828244b-f63b-4c8d-8f71-837c6fc4e93f","deviceId":"9b6f6448","userId":"ca9fecbc-d1fe-43a5-b110-82cc6c30cd83","isInternal":"False","authenticatedUserId":"877887d3-d734-4c29-b937-6381ed62257f","ProductVersion":"2.75.5649.961 (19.11)","ActivityId":"e6a95eb0-6103-4c48-8265-3a7b583903c9","Process":"PBIDesktop","Pid":17392,"Tid":1,"Duration":"00:00:00.0004269"}
DataMashup.Trace Warning: 24579 : {"Start":"2019-12-04T08:03:16.4491456Z","Action":"DataImporterAddSource","sourceFormulaId":"formulaAnalysisServicesDatabases","GetDataFlow.sourceFormulaId":"formulaAnalysisServicesDatabases","sessionId":"1828244b-f63b-4c8d-8f71-837c6fc4e93f","deviceId":"9b6f6448","userId":"ca9fecbc-d1fe-43a5-b110-82cc6c30cd83","isInternal":"False","authenticatedUserId":"877887d3-d734-4c29-b937-6381ed62257f","ProductVersion":"2.75.5649.961 (19.11)","ActivityId":"43ddaaaf-8b86-4ac3-a767-8eb202459da9","Process":"PBIDesktop","Pid":17392,"Tid":1,"Duration":"00:00:00.0010272"}
DataMashup.Trace Warning: 24579 : {"Start":"2019-12-04T08:03:16.5294237Z","Action":"PackagePartitionAnalysisInfo/SetPreviewValue","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Host.Document.Analysis.IncompleteFormulaAnalysisException, Microsoft.Mashup.Document, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: Input task 'Source' is incomplete.\r\nStackTrace:\n   at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)\r\n\r\n\r\n","ProductVersion":"2.75.5649.961 (19.11)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":17392,"Tid":15,"Duration":"00:00:00.0067666"}
DataMashup.Trace Warning: 24579 : {"Start":"2019-12-04T08:03:17.0595465Z","Action":"BuilderShown","isNewQuery":"True","builderFormulaId":"formulaAnalysisServicesDatabases","GetDataFlow.sourceFormulaId":"formulaAnalysisServicesDatabases","sessionId":"1828244b-f63b-4c8d-8f71-837c6fc4e93f","deviceId":"9b6f6448","userId":"ca9fecbc-d1fe-43a5-b110-82cc6c30cd83","isInternal":"False","authenticatedUserId":"877887d3-d734-4c29-b937-6381ed62257f","ProductVersion":"2.75.5649.961 (19.11)","ActivityId":"832a8b28-b327-464d-b3c3-591bb9c3811b","Process":"PBIDesktop","Pid":17392,"Tid":1,"Duration":"00:00:00.0009323"}
DataMashup.Trace Warning: 24579 : {"Start":"2019-12-04T08:03:35.9110964Z","Action":"SourceBuilderCommitting","isNewQuery":"True","builderFormulaId":"formulaAnalysisServicesDatabases","connectionMode":"Import","dataImportDestination":"Auto","GetDataFlow.sourceFormulaId":"formulaAnalysisServicesDatabases","sessionId":"1828244b-f63b-4c8d-8f71-837c6fc4e93f","deviceId":"9b6f6448","userId":"ca9fecbc-d1fe-43a5-b110-82cc6c30cd83","isInternal":"False","authenticatedUserId":"877887d3-d734-4c29-b937-6381ed62257f","ProductVersion":"2.75.5649.961 (19.11)","ActivityId":"720ee536-af56-411b-b3dc-7dff0604d627","Process":"PBIDesktop","Pid":17392,"Tid":1,"Duration":"00:00:00.0006563"}
DataMashup.Trace Warning: 24579 : {"Start":"2019-12-04T08:03:37.5018429Z","Action":"BuilderCommitted","isNewQuery":"True","builderFormulaId":"formulaAnalysisServicesDatabases","GetDataFlow.sourceFormulaId":"formulaAnalysisServicesDatabases","sessionId":"1828244b-f63b-4c8d-8f71-837c6fc4e93f","deviceId":"9b6f6448","userId":"ca9fecbc-d1fe-43a5-b110-82cc6c30cd83","isInternal":"False","authenticatedUserId":"877887d3-d734-4c29-b937-6381ed62257f","ProductVersion":"2.75.5649.961 (19.11)","ActivityId":"d7aacc7e-3904-4869-9ad8-493bd7bf93e1","Process":"PBIDesktop","Pid":17392,"Tid":1,"Duration":"00:00:00.0000726"}
DataMashup.Trace Warning: 24579 : {"Start":"2019-12-04T08:03:38.1331545Z","Action":"PBI.PQ.DataImporterInternal","message":"DataSourceType:'CubeDatabase', SourceID:'formulaAnalysisServicesDatabases'","activeView":"Reports","actionId":"DataImporterGetPreviewResultInternal","parentId":"7b373ffa-7996-4b28-a437-eb1977fc2626","isError":"False","sessionId":"1828244b-f63b-4c8d-8f71-837c6fc4e93f","deviceId":"9b6f6448","userId":"ca9fecbc-d1fe-43a5-b110-82cc6c30cd83","isInternal":"False","authenticatedUserId":"877887d3-d734-4c29-b937-6381ed62257f","ProductVersion":"2.75.5649.961 (19.11)","ActivityId":"8b339fa3-6f3d-493d-8814-452a1a7e9eed","Process":"PBIDesktop","Pid":17392,"Tid":1,"Duration":"00:00:00.0008629"}
DataMashup.Trace Warning: 24579 : {"Start":"2019-12-04T08:03:39.8396011Z","Action":"NavigatorDialogShown","GetDataFlow.sourceFormulaId":"formulaAnalysisServicesDatabases","sessionId":"1828244b-f63b-4c8d-8f71-837c6fc4e93f","deviceId":"9b6f6448","userId":"ca9fecbc-d1fe-43a5-b110-82cc6c30cd83","isInternal":"False","authenticatedUserId":"877887d3-d734-4c29-b937-6381ed62257f","ProductVersion":"2.75.5649.961 (19.11)","ActivityId":"d249c5ec-5c0c-4dc0-b92d-cc8a8012d42f","Process":"PBIDesktop","Pid":17392,"Tid":1,"Duration":"00:00:00.0007214"}
DataMashup.Trace Warning: 24579 : {"Start":"2019-12-04T08:14:18.2915976Z","Action":"PBI.PQ.Navigator","actionId":"EditorNavigatorCancelLoad","sessionId":"1828244b-f63b-4c8d-8f71-837c6fc4e93f","deviceId":"9b6f6448","userId":"ca9fecbc-d1fe-43a5-b110-82cc6c30cd83","isInternal":"False","authenticatedUserId":"877887d3-d734-4c29-b937-6381ed62257f","ProductVersion":"2.75.5649.961 (19.11)","ActivityId":"5397df6e-813a-4908-963b-bd2c60aa4c1c","Process":"PBIDesktop","Pid":17392,"Tid":1,"Duration":"-00:00:00.0137904"}
DataMashup.Trace Warning: 24579 : {"Start":"2019-12-04T08:14:18.2945897Z","Action":"NavigatorDialogClosed","numberOfQueriesCommitted":"0","navigatorDialogResult":"Cancel","hasErrorNodes":"False","isExceptionPreviewDisplayed":"True","GetDataFlow.sourceFormulaId":"formulaAnalysisServicesDatabases","sessionId":"1828244b-f63b-4c8d-8f71-837c6fc4e93f","deviceId":"9b6f6448","userId":"ca9fecbc-d1fe-43a5-b110-82cc6c30cd83","isInternal":"False","authenticatedUserId":"877887d3-d734-4c29-b937-6381ed62257f","ProductVersion":"2.75.5649.961 (19.11)","ActivityId":"29893620-9def-474a-a4ac-b3fa172f78e0","Process":"PBIDesktop","Pid":17392,"Tid":1,"Duration":"-00:00:00.0137988"}

How to proceed from here?

I suppose downgrading is not an option, the same error appeared also when published to the cloud.