You plan to use Power BI Desktop to create an analytics solution for the data. You need to create a relationship between the Order table and the Store table on the Store_ID column. What should you do before you create the relationship?
A. In the Order table query, use the Table.TrasformRows function.
B. In the Store table query, use the Table.TrasformRows function.
C. In the Store table query, use the Table.TrasformColumnTypes function.
D. In the Order table query, use the Table.TrasformColumnTypes function.
Answer:C
You plan to use Power BI Desktop to create an analytics solution for the data. You need to create a relationship between the Order table and the Store table on the Store_ID column. What should you do before you create the relationship?
A. In the Order table query, use the Table.TrasformRows function. B. In the Store table query, use the Table.TrasformRows function. C. In the Store table query, use the Table.TrasformColumnTypes function. D. In the Order table query, use the Table.TrasformColumnTypes function.