This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
When connecting to a SQL Server database to get data, what language should you use to extract data?
DAX
T-SQL
MDX
You're creating a Power BI report with data from an Azure Analysis Services MDX Cube. When the data refreshes in the cube, you would like to see it immediately in the Power BI report. How should you connect?
Import
Live connection
What can you do to improve performance when you're getting data in Power BI?
Remove unnecessary columns and rows
Export database files to CSV to load
Combine date and time columns into a single column
You must answer all questions before checking your work.
Was this page helpful?