additional prepare the data questions
how can you resolve the following data import error: could not find flat file
- if file location has changed, change the source settings
how can you resolve the following data import error: "query timeout expired"
- pull fewer columns or rows from a single table - remove added complexities (aggregations, groupings, joins) - if you need the rows, complexities, and columns, then take small chunks of data and bring them back together using power query
how can you resolve the following data import error: "we couldn't find any data formatted as a table"
open your excel workbook, highlight the data you want to import, press ctrl+t on the keyboard. then try to reimport.
what data shape transformation is useful when you have different measures mixed in the same column (i.e., quantity and price labels in one column and the values in another)
pivot column
when you are importing data and you get the error "query timeout expired", this indicates that you've
pulled too much data according to organizational policies
how can you resolve the following data import error: data type errors
resoolution is unique to data source (ex: if using sql, convert to correct data type in the query)
how do you configure data loading
right click the query in the queries pane and clear the enable load section
what data shape transformation is useful when you have multiple level of headersq
transpose
what data shape transformation do you use to transform columns into two: attribute (containing old column names), and value (contain old column values)
unpivot columns
what data shape transformation is useful when source has been prepared using a pivot table
unpivot columns
