Cuando creé un objeto visual de preguntas y respuestas en Power BI Desktop y hice clic en la configuración, luego elegí "Revisar preguntas",
saldrá "Algo salió mal", y toda la aplicación se atascó, no puedo hacer clic en nada,
y cuando hago clic en "Copiar detalles al tablero de tablero", muestra el siguiente mensaje de error:
Tipo de retroalimentación:
Fruncir el ceño (error)
Timestamp:
2021-11-23T08:39:34.3139951Z
Hora local:
2021-11-23T16:39:34.3139951+08:00
ID de sesión:
c0a72146-3724-46b7-8704-dea8ff6ae360
Lanzamiento:
Noviembre 2021
Versión del producto:
2.99.621.0 (21.11) (x64)
Versión del sistema operativo:
Microsoft Windows NT 10.0.22000.0 (x64 en-US)
Versión clR:
4.7 o posterior [Número de versión = 528449]
Memoria virtual pico:
103 GB
Memoria privada:
1,02 GB
Conjunto de trabajo pico:
1,16 GB
Versión de IE:
11.1.22000.0
ID de usuario:
5c2a9f0d-dbd5-4c01-8201-7a8ec0d953ab
Información del paquete del libro:
1* - en-US, Grupos de consultas: 0, fastCombine: Enabled, runBackgroundAnalysis: False.
Telemetría habilitada:
Verdadero
Registros de seguimiento de instantáneas:
C:Usuariosqimzhou. FAREASTMicrosoftPower BI Desktop Store AppFrownSnapShoteebc37d8-d960-47b4-8881-85c01fad8419.zip
Modo predeterminado del modelo:
Importación
Versión del modelo:
PowerBI_V3
Registros de seguimiento de rendimiento:
C:Usuariosqimzhou. FAREASTMicrosoftPower BI Desktop Store AppPerformanceTraces.zip
Funciones de vista previa habilitadas:
PBI_rdlNativeVisual
Características de vista previa deshabilitadas:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_compositeModelsOverAS
PBI_dynamicParameters
PBI_enhancedTooltips
PBI_useModernFormatPane
PBI_scorecardVisual
Opciones de DirectQuery deshabilitadas:
TreatHanaAsRelationalSource
Nube:
GlobalCloud
Escala DPI:
200%
Servicios soportados:
Power BI
Fórmulas:
sección Sección1;
ventas compartidas = let
Source = Excel.Workbook(File.Contents("C:UsersamacOneDrive - MicrosoftReports and Datasets2016 09 06 Contoso.xlsx"), null, true),
Sales_Table = Source{[Item="Sales",Kind="Table"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(Sales_Table,{{"SalesOrderID", type text}, {"Country", type text}, {"OrderDate", type date}, {"SalesChannelCode", type text}, {"ProdID", Int64.Type}, {"StyleName", type text}, {"CustomerAccountNumber", type text}, {"StoreKey", Int64.Type}, {"ProductLabel", Int64.Type}, {"ProductName", type text}, {"ProductDescription", type text}, {"Manufacturer", type text}, {"BrandName", type text}, {"Class", type text}, {"Color", type text}, {"StockType", type text}, {"StockType", type text}, {"Units", Int64.Type}, {"SalesAmount", type number}, {"NSAT", Int64.Type}, {"SubCategory", type text}, {"Category", type text}}),
#"Added Conditional Column" = Table.AddColumn(#"Changed Type", "Custom", each if [SalesAmount] >= 5000 then "Large" else if [SalesAmount] >= 1000 then "Medium" else "Small"),
#"Split Column by Delimiter" = Table.SplitColumn(#"Added Conditional Column", "ProductName", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.csv, true), {"ProductName.1", "ProductName.2"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"ProductName.1", type text}, {"ProductName.2", type text}}),
#"Columnas eliminadas" = Table.RemoveColumns(#"Changed Type1",{"ProductName.2"}),
#"Renamed Columns1" = Table.RenameColumns(#"Columnas eliminadas",{{"ProductName.1", "ProductName"}, {"Custom", "Sale Size"}})
en
#"Columnas renombradas1";
Calendario compartido = let
Fuente = Table.FromRows(Json.Document(Binary.Decompress(Binary. FromText("XdhBruXWDkPRuaT9AYs8lmWPJcj8p/ERVNULt5psed1D3Ib4999/6dLlkv7653//Bmc4Ge4MneHJMBneDF8GFRIMAkJQCAzBIUAEiUARLIbFfA9YDIthMSyGxbAYFsNyYDlh8YXgDCfDnaEzPBkmw5vhw0cLiSAgBIXAEBwCRJAIFMFiWMz3gMWwGBbDYlgMSxZ18vlPPv/J5z/5/Cef/+Tzn3z+c+E7Hz5aSDAICEEhMASHABEk4k+GxbCY7wGLYTEshsWwGBY+v2E5sOT/5L4QnOFkuDN0hifDZHgzfPhoIREEhKAQGIJDgAgSgSJYDIv5HrAYFsNiWAyLYTEshiWL6qyms5rOajqr6ayms5rOajqr6aym2jmkY1jWoa1TSqaVTTtqKZRTaOaRjWNahrVNKppVNOoplFNo5pGNY1qelWT/ 6HnQnCGk+HO0BmeDJPhzfDho4VEEBCCQmAIDgEiSASKYDEs5nvAYlgMi2ExLIbFsBiWLGqymslqJquZrGaymslqJquZrGaymkE1g2oG1QyqGVQzqGZQzaCaQTWDagbVDKoZVDOoZlDNoJpBNYNqBtUMqplVTf6H3gvBGU6GO0NneDJMhjfDh48WEkFACAqBITgEiCARKILFsJjvAYthMSyGxbAYFsNiWA4sWdR3ITjDyXBn6AxPhsnwZvjw0UIiCAhBITAEhwARJAJFsBgW8z1gMSyGxbAYFsNiWAwLLqDCdVo4Twv3aeFALVyohRO1cKMWjtTClVo8U4t3avFQLV6qxVO1eKsWj9XitVo8V4v3aqGuf+N6I6pMlakyVabKVJkqU7WKy7+ YuDJwZuDOwKGBSwOnBm4NHBu4Nqy5Ye0Na3BYi8OaHNbmsEaHtTqs2WHtDmt4WMvDmh7W9rDGh7U+rPlh7Q9rgFgLxJogsDoIs4OwOwjDg7A8CNODsD0I44OwPojzg7g/iAOEuECIE4S4QYgjhLhCiDOEuEOIQ4S4RIhThLhFiGOEuEaIc4S4R4iDxL+RqlUc/oC/ avTv4Awnw52hMzwZJsOb4cvwq72fBIOAEBQCQ3AIEEEiUASLYTHfAxbDYlgMi2ExLIbFsBxYTlh8ITjDyXBn6AxPhsnwZvjw0UIiCAhBITAEhwARJAJFsBgW8z1gMSyGxbAYFsNiWLKok2WcLONkGSfLOFnGyTJOlnGyjHPxo4UEg4AQFAJDcAgQQSJQBIthMd8DFsNiWAyLYTEshoVlHFjyX3NfCM5wMtwZOsOTYTK8GT58tJAIAkJQCAzBIUAEiUARLIbFfA9YDIthMSyGxbAYFsOSRXVW01lNZzWd1XRW01lNZzWd1XRW06imUU2jmkY1jWoa1TSqaVTTqKZRTaOaRjWNahrVNKppVNOoplFNo5pGNb2qyf/QcyE4w8lwZ+ gMT4bJ8Gb48NFCIggIQSEwBIcAESQCRbAYFvM9YDEshsWwGBbDYlgMSxY1Wc1kNZPVTFYzWc1kNZPVTFYzWc2gmkE1g2oG1QyqGVQzqGZQzaCaQTWDagbVDKoZVDOoZlDNoJpBNYNqBtXMqib/Q++F4Awnw52hMzwZJsOb4cNHC4kgIASFwBAcAkSQCBTBYljM94DFsBgWw2JYDIthMSwHlizquxCc4WS4M3SGJ8NkeDN8+GghEQSEoBAYgkOACBKBIlgMi/kesBgWw2JYDIthMSyGBfdQ4VYtHKuFa7Vwrhbu1cLBWrhYCydr4WYtHq3Fq7V4thbv1uLhWrxci6dr8XYtHq/F67VQ18/m91+kylSZKlNlqkyVqTJVq7j8i4mbA0cHrg6cHbg7cHjg8sDpgdvDGh/W+rDmh7U/ rAFiLRBrglgbxBoh1gqxZoi1Q6whYi0Ra4pYW8QaI9YaseaItUesQQIbxJ/N7ycdpBupkR6kQXqRPn59YagROaJHBIkikSSaRJSoMlVeb0SVqTJVpspUmSpTZapWcfgD/qrx/A7OcDLcGTrDk2EyvBm+DL/a+0kwCAhBITAEhwARJAJFsBgW8z1gMSyGxbAYFsNiWAzLgeWExReCM5wMd4bO8GSYDG+GDx8tJIKAEBQCQ3AIEEEiUASLYTHfAxbDYlgMi2ExLFnUyec/+fwnn//k8598/pPPf/L5z4XvfPhoIcEgIASFwBAcAkSQiD8ZFsNivgcshsWwGBbDYlj4/IblwJL/k/tCcIaT4c7QGZ4Mk+HN8OGjhUQQEIJCYAgOASJIBIpgMSzme8BiWAyLYTEshsWwGJYsqrOazmo6q+msprOazmo6q+ msprOaRjWNahrVNKppVNOoplFNo5pGNY1qGtU0qmlU06imUU2jmkY1jWoa1TSq6VVN/oeeC8EZToY7Q2d4MkyGN8OHjxYSQUAICoEhOASIIBEogsWwmO8Bi2ExLIbFsBgWw2JYsqjJaiarmaxmsprJaiarmaxmsprJagbVDKoZVDOoZlDNoJpBNYNqBtUMqhlUM6hmUM2gmkE1g2oG1QyqGVQzqGZWNfkfei8EZzgZ7gyd4ckwGd4MHz5aSAQBISgEhuAQIIJEoAgWw2K+ByyGxbAYFsNiWAyLYTmwZFHfheAMJ8OdoTM8GSbDm+HDRwuJICAEhcAQHAJEkAgUwWJYzPeAxbAYFsNiWAyLYTEsuIAK12nhPC3cp4UDtXChFk7Uwo1aOFILV2rxTC3eqcVDtXipFk/V4q1aPFaL12rxXC3eq4W6fla+/ yJVpspUmSpTZapMlalaxeVfTFwZODNwZ+DQwKWBUwO3Bo4NXBvW3LD2hjU4rMVhTQ5rc1ijw1od1uywdoc1PKzlYU0Pa3tY48NaH9b8sPaHNUCsBWJNEFgd/qx8P+kg3UiN9CAN0ov08esLQ43IET0iSBSJJNEkokSVqfJ6I6pMlakyVabKVJkqU7WKwx/wV4337+AMJ8OdoTM8GSbDm+HL8Ku9nwSDgBAUAkNwCBBBIlAEi2Ex3wMWw2JYDIthMSyGxbAcWE5YfCE4w8lwZ+gMT4bJ8Gb48NFCIggIQSEwBIcAESQCRbAYFvM9YDEshsWwGBbDkkWdfP6Tz3/y+U8+/8nnP/n8J5//XPjOh48WEgwCQlAIDMEhQASJ+JNhMSzme8BiWAyLYTEshoXPb1gOLPk/ uS8EZzgZ7gyd4ckwGd4MHz5aSAQBISgEhuAQIIJEoAgWw2K+ByyGxbAYFsNiWAyLYcmiOqvprKazms5qOqvprKazms5qOqtpVNOoplFNo5pGNY1qGtU0qmlU06imUU2jmkY1jWoa1TSqaVTTqKZRTaOaXtXkf+i5EJzhZLgzdIYnw2R4M3z4aCERBISgEBiCQ4AIEoEiWAyL+R6wGBbDYlgMi2ExLIYli5qsZrKayWomq5msZrKayWomq5msZlDNoJpBNYNqBtUMqhlUM6hmUM2gmkE1g2oG1QyqGVQzqGZQzaCaQTWDamZVk/+ h90JwhpPhztAZngyT4c3w4aOFRBAQgkJgCA4BIkgEimAxLOZ7wGJYDIthMSyGxbAYlgNLFvVdCM5wMtwZOsOTYTK8GT58tJAIAkJQCAzBIUAEiUARLIbFfA9YDIthMSyGxbAYFsOCC6hwnRbO08J9WjhQCxdq4UQt3KiFI7VwpRbP1OKdWjxUi5dq8VQt3qrFY7V4rRbP1eK9WqjrZ+X7L1JlqkyVqTJVpspUmapVXP7FxJWBMwN3Bg4NXBo4NXBr4NjAtWHNDWtvWIPDWhzW5LA2hzU6rNVhzQ5rd1jDw1oe1vSwtoc1Pqz1Yc0Pa39YA8RaINYEgdXhz8r3kw7SjdRID9IgvUgfv74w1Igc0SOCRJFIEk0iSlSZKq83ospUmSpTZapMlakyVas4/AF/1di/gzOcDHeGzvBkmAxvhi/Dr/Z+ EgwCQlAIDMEhQASJQBEshsV8D1gMi2ExLIbFsBgWw3JgOWHxheAMJ8OdoTM8GSbDm+HDRwuJICAEhcAQHAJEkAgUwWJYzPeAxbAYFsNiWAxLFnXy+U8+/8nnP/n8J5//5POffP5z4TsfPlpIMAgIQSEwBIcAESTiT4bFsJjvAYthMSyGxbAYFj6/YTmw5P/kvhCc4WS4M3SGJ8NkeDN8+GghEQSEoBAYgkOACBKBIlgMi/kesBgWw2JYDIthMSyGJYvqrKazms5qOqvprKazms5qOqvprKZRTaOaRjWNahrVNKppVNOoplFNo5pGNY1qGtU0qmlU06imUU2jmkY1jWp6VZP/oedCcIaT4c7QGZ4Mk+ HN8OGjhUQQEIJCYAgOASJIBIpgMSzme8BiWAyLYTEshsWwGJYsarKayWomq5msZrKayWomq5msZrKaQTWDagbVDKoZVDOoZlDNoJpBNYNqBtUMqhlUM6hmUM2gmkE1g2oG1QyqmVVN/ofeC8EZToY7Q2d4MkyGN8OHjxYSQUAICoEhOASIIBEogsWwmO8Bi2ExLIbFsBgWw2JYDixZ1HchOMPJcGfoDE+GyfBm+PDRQiIICEEhMASHABEkAkWwGBbzPWAxLIbFsBgWw2JYDAsuoMJ1WjhPC/dp4UAtXKiFE7VwoxaO1MKVWjxTi3dq8VAtXqrFU7V4qxaP1eK1WjxXi/dqoa6fle+/SJWpMlWmylSZKlNlqlZx+ RcTVwbODNwZODRwaeDUwK2BYwPXhjU3rL1hDQ5rcViTw9oc1uiwVoc1O6zdYQ0Pa3lY08PaHtb4sNaHNT+s/WENEGuBWBMEVoc/K99POkg3UiM9SIP0In38+sJQI3JEjwgSRSJJNIkoUWWqvN6IKlNlnkyVqTJVpspUreJ+/oD//B8=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) en la tabla de tipos [Date = _t]),
#"Tipo cambiado" = Table.TransformColumnTypes(Origen,{{"Fecha", tipo fecha}}),
#"Nombre de mes insertado" = Table.AddColumn(#"Tipo cambiado", "Nombre de mes", cada Date.MonthName([Fecha]), escriba texto),
#"Primeros caracteres extraídos" = Table.TransformColumns(#"Nombre del mes insertado", {{"Nombre del mes", cada texto.Start(_, 3), escriba texto}}),
#"Columnas renombradas" = Table.RenameColumns(#"Primeros caracteres extraídos",{{"Nombre del mes", "Mes"}}),
#"Año insertado" = Table.AddColumn(#"Columnas renombradas", "Año", cada Fecha.Año([Fecha]), Int64.Type),
#"Changed Type1" = Table.TransformColumnTypes(#"Año insertado",{{"Año", escriba texto}}),
#"Mes insertado" = Table.AddColumn(#"Changed Type1", "Month.1", each Date.Month([Date]), Int64.Type),
#"Columnas renombradas1" = Table.RenameColumns(#"Mes insertado",{{"Mes.1", "MesN"}}),
#"Columnas reordenadas" = Table.ReorderColumns(#"Columnas renombradas1",{"Fecha", "Mes", "MesN", "Año"})
en
#"Columnas reordenadas";
compartido #"Detalles del pedido" = let
Fuente = OData.Feed("http://services.odata.org/V3/Northwind/Northwind.svc/"),
Order_Details_table = Origen{[Nombre="Order_Details",Firma="tabla"]}[Datos]
en
Order_Details_table;
[ Descripción = "Ubicación de los datos de ventas" ]Shared FileLocation = meta "C:Data" [IsParameterQuery=true, Type="Text", IsParameterQueryRequired=true];
productos compartidos = let
Source = Excel.Workbook(File.Contents("C:UsersamacOneDrive - MicrosoftReports and Datasets2016 09 06 Contoso.xlsx"), null, true),
Products_Table = Source{[Item="Products",Kind="Table"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(Products_Table,{{"ProductKey", Int64.Type}, {"ProductLabel", Int64.Type}, {"ProductName", type text}, {"ProductDescription", type text}, {"Manufacturer", type text}, {"BrandName", type text}, {"Class", type text}, {"StyleName", Int64.Type}, {"ColorName", type text}, {"StockTypeName", type text}, {"UnitCost", type number}, {"UnitPrice", type number}, {"SubCategory", type text}, {"GeneralCategory", type text}})
en
#"Tipo cambiado";
tiendas compartidas = let
Source = Excel.Workbook(File.Contents("C:UsersamacOneDrive - MicrosoftReports and Datasets2016 09 06 Contoso.xlsx"), null, true),
Stores_Table = Source{[Item="Stores",Kind="Table"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(Stores_Table,{{"StoreKey", Int64.Type}, {"GeographyKey", Int64.Type}, {"StoreManager", Int64.Type}, {"StoreType", type text}, {"StoreName", type text}, {"StoreDescription", type text}, {"Status", type text}, {"ZipCode", Int64.Type}, {"ZipCodeExtension", Int64.Type}, {"StorePhone", type text}, {"StoreFax", type text}, {"AddressLine1", type text}, {"AddressLine2", type text}, {"EmployeeCount", Int64.Type}, {"SellingAreaSize", Int64.Type}, {"GeoLocation", escriba texto}, {"Geometría", escriba texto}})
en
#"Tipo cambiado";
Inventario compartido = dejar
Source = Excel.Workbook(File.Contents("C:UsersamacOneDrive - MicrosoftReports and Datasets2016 09 06 Contoso.xlsx"), null, true),
Inventory_Table = Source{[Item="Inventory",Kind="Table"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(Inventory_Table,{{"InventoryRecID", Int64.Type}, {"InvDate", type date}, {"StoreKey", Int64.Type}, {"ProductKey", Int64.Type}, {"ComboKey", type number}, {"OnHandQuantity", Int64.Type}, {"OnOrderQuantity", Int64.Type}, {"SafetyStockQuantity", Int64.Type}, {"UnitCost", type number}, {"DaysInStock", Int64.Type}, {"MinDayInStock", Int64.Type}, {"MaxDayInStock", Int64.Type}, {"Aging", Int64.Type}})
en
#"Tipo cambiado";
WindowsOS: Win11
