Después de actualizar el escritorio de junio de 2019 a noviembre de 2019, no se puede conectar a Cube

Un usuario Pregunto ✅

kakkaroolari

ANTECEDENTES:

Tengo un modelo tabular implementado en SSAS

CUÁNDO

Hago clic en Obtener datos -> SSAS

ENTONCES

Veo el mensaje de error «Restricción única no encontrada»

Error_Olap_Cubo.png

Esto estaba funcionando en el escritorio de junio de 2019

¿Qué necesito arreglar?

¿Cómo puedo ver los mensajes de error detallados? ¿Es eso posible?

Hola @kakkaroolari

Lo siento, no puedo reproducir tu problema de mi parte.

Puede habilitar la siguiente opción y verificar el registro:

007.PNG

Si desea reinstalar la versión anterior, puede consultar:

https://winaero.com/blog/restaurar-versiones-anteriores-windows-10/

kakkaroolari

En respuesta a v-diye-msft

Ok, logré obtener rastros de registro.

Entonces, ¿qué necesito encontrar en los registros?

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

Veo excepciones internas en el escritorio powerbi, pero aún no tengo idea de cómo solucionar el problema.

Una excepción es: 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:rnExceptionType: Microsoft.Mashup.Host.Document.Analysis.IncompleteFormulaAnalysisException, Microsoft.Mashup.Document, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35rnMessage: Input task 'Source' is incomplete.rnStackTrace:n   at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)rnrnrn","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"}

¿Cómo proceder desde aquí?

Supongo que degradar no es una opción, también apareció el mismo error cuando se publicó en la nube.

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *