SEARCH
You are in browse mode. You must login to use MEMORY

   Log in to start


From course:

POWER BI [PI-300]

» Start this Course
(Practice similar questions for free)
Question:

You create a Power BI data source which uses a SQL SELECT statement. The SQL statement queries multiple tables in a SQL Server database and includes subqueries. After you import data from the data source into Power BI, you notice that one of the columns in the resulting dataset appears blank. You verify that the source table does include data. What should you do to resolve the issue?Select only one answer. Clear permissions on the data source in Power BI. Use the CAST function in the SQL statement. Use the DATALENGTH function in the SQL statement. Set the privacy levels on the data source.

Author: da-bi



Answer:

Use the CAST function in the SQL statement. This answer is correct.


0 / 5  (0 ratings)

1 answer(s) in total

Author

da-bi
da-bi