When I created a Q&A visual in Power BI Desktop and click the setting, then choose "Review Questions",
it will pop out "Something went wrong", and the whole application got stuck, I cannot click anything,
and when i click the "Copy details to dash board", it shows the below error message:
Feedback Type:
Frown (Error)
Timestamp:
2021-11-23T08:39:34.3139951Z
Local Time:
2021-11-23T16:39:34.3139951+08:00
Session ID:
c0a72146-3724-46b7-8704-dea8ff6ae360
Release:
November 2021
Product Version:
2.99.621.0 (21.11) (x64)
OS Version:
Microsoft Windows NT 10.0.22000.0 (x64 en-US)
CLR Version:
4.7 or later [Release Number = 528449]
Peak Virtual Memory:
103 GB
Private Memory:
1.02 GB
Peak Working Set:
1.16 GB
IE Version:
11.1.22000.0
User ID:
5c2a9f0d-dbd5-4c01-8201-7a8ec0d953ab
Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Enabled, runBackgroundAnalysis: False.
Telemetry Enabled:
True
Snapshot Trace Logs:
C:\Users\qimzhou.FAREAST\Microsoft\Power BI Desktop Store App\FrownSnapShoteebc37d8-d960-47b4-8881-85c01fad8419.zip
Model Default Mode:
Import
Model Version:
PowerBI_V3
Performance Trace Logs:
C:\Users\qimzhou.FAREAST\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip
Enabled Preview Features:
PBI_rdlNativeVisual
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_compositeModelsOverAS
PBI_dynamicParameters
PBI_enhancedTooltips
PBI_useModernFormatPane
PBI_scorecardVisual
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
200%
Supported Services:
Power BI
Formulas:
section Section1;
shared Sales = let
Source = Excel.Workbook(File.Contents("C:\Users\amac\OneDrive - Microsoft\Reports and Datasets\2016 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}, {"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}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type1",{"ProductName.2"}),
#"Renamed Columns1" = Table.RenameColumns(#"Removed Columns",{{"ProductName.1", "ProductName"}, {"Custom", "Sale Size"}})
in
#"Renamed Columns1";
shared Calendar = let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("XdhBruXWDkPRuaT9AYs8lmWPJcj8p/ERVNULt5psed1D3Ib4999/6dLlkv7653//Bmc4Ge4MneHJMBneDF8GFRIMAkJQCAzBIUAEiUARLIbFfA9YDIthMSyGxbAYFsNyYDlh8YXgDCfDnaEzPBkmw5vhw0cLiSAgBIXAEBwCRJAIFMFiWMz3gMWwGBbDYlgMSxZ18vlPPv/J5z/5/Cef/+Tzn3z+c+E7Hz5aSDAICEEhMASHABEk4k+GxbCY7wGLYTEshsWwGBY+v2E5sOT/5L4QnOFkuDN0hifDZHgzfPhoIREEhKAQGIJDgAgSgSJYDIv5HrAYFsNiWAyLYTEshiWL6qyms5rOajqr6ayms5rOajqr6aymUU2jmkY1jWoa1TSqaVTTqKZRTaOaRjWNahrVNKppVNOoplFNo5pGNY1qelWT/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+sJQI3JEjwgSRSJJNIkoUWWqvN6IKlNlqkyVqTJVpspUreJ+/oD//B8=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Date = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}}),
#"Inserted Month Name" = Table.AddColumn(#"Changed Type", "Month Name", each Date.MonthName([Date]), type text),
#"Extracted First Characters" = Table.TransformColumns(#"Inserted Month Name", {{"Month Name", each Text.Start(_, 3), type text}}),
#"Renamed Columns" = Table.RenameColumns(#"Extracted First Characters",{{"Month Name", "Month"}}),
#"Inserted Year" = Table.AddColumn(#"Renamed Columns", "Year", each Date.Year([Date]), Int64.Type),
#"Changed Type1" = Table.TransformColumnTypes(#"Inserted Year",{{"Year", type text}}),
#"Inserted Month" = Table.AddColumn(#"Changed Type1", "Month.1", each Date.Month([Date]), Int64.Type),
#"Renamed Columns1" = Table.RenameColumns(#"Inserted Month",{{"Month.1", "MonthN"}}),
#"Reordered Columns" = Table.ReorderColumns(#"Renamed Columns1",{"Date", "Month", "MonthN", "Year"})
in
#"Reordered Columns";
shared #"Order Details" = let
Source = OData.Feed("http://services.odata.org/V3/Northwind/Northwind.svc/"),
Order_Details_table = Source{[Name="Order_Details",Signature="table"]}[Data]
in
Order_Details_table;
[ Description = "Location for the Sales Data" ]shared FileLocation = "C:\Data" meta [IsParameterQuery=true, Type="Text", IsParameterQueryRequired=true];
shared Products = let
Source = Excel.Workbook(File.Contents("C:\Users\amac\OneDrive - Microsoft\Reports and Datasets\2016 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}})
in
#"Changed Type";
shared Stores = let
Source = Excel.Workbook(File.Contents("C:\Users\amac\OneDrive - Microsoft\Reports and Datasets\2016 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", type text}, {"Geometry", type text}})
in
#"Changed Type";
shared Inventory = let
Source = Excel.Workbook(File.Contents("C:\Users\amac\OneDrive - Microsoft\Reports and Datasets\2016 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}})
in
#"Changed Type";
WindowsOS: Win11
