How to Transition from SSRS to Power BI Using DirectQuery for MB-500 Exam Success?
Table of Contents
Question
Your company uses Microsoft Power BI for data exploration and visualization. Recently, the company has decided to shift from using SSRS reports to Power BI for non-document reports.
You need to ensure that the transition is smooth and the users can interactively explore large volumes of data without creating multiple views of the same data.
Which tool should you recommend for this purpose?
Select only one answer.
A. PowerPivot extension in Excel
B. DirectQuery technology in Power BI
C. Power Query extension in Excel
D. SSRS integration
Answer
B. DirectQuery technology in Power BI
Explanation
DirectQuery technology in Power BI allows creation of reports over large volumes of data without caching data in the PowerBI.com service. Power Query and PowerPivot extensions in Excel are used for creating visualizations and ingesting larger amount of data into Excel respectively, but they do not provide interactive data exploration like Power BI. SSRS integration is used for document-style reports, not for interactive data exploration.
Microsoft Dynamics 365: Finance and Operations Apps Developer MB-500 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Microsoft Dynamics 365: Finance and Operations Apps Developer MB-500 exam and earn Microsoft Dynamics 365: Finance and Operations Apps Developer MB-500 certification.