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»
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?
v-diye-msft
Hola @kakkaroolari
Lo siento, no puedo reproducir tu problema de mi parte.
Puede habilitar la siguiente opción y verificar el registro:
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.