HOTSPOT (Drag and Drop is not supported)You create reports within Power BI to report on the status of a project. A manager asks you to share the reports with other team members. You decide to create a published app and set permissions to allow other team members to view the reports.For each of the following statements, select Yes if the statement is true. Otherwise, select No.Note: Each correct selection is worth one point.Hot Area:
Answer(s): A
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-create-distribute-apps
DRAG DROP (Drag and Drop is not supported)A company plans to create an information portal that managers can use to view critical information about their teams.You need to recommend the type of Power BI components that the company should use.What should you recommend? To answer, drag the appropriate component types to the correct requirements. Each component type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.NOTE. Each correct selection is worth one point.Select and Place:
Box 1: ReportReports are more detailed data displayed in many formats like chart, graphs list and in tabular, etc.Box 2: DashboardDashboards are a business key performance indicator view where it displays key values that can change business profits and can be glanced at one screen.Box 3: ReportPower BI dashboards cannot slice and dice, but reports have many ways to filter and slice.Note: Power BI dashboards are one placeholder to display the most important decision-making facts to run a business. But reports are more detailed data displayed in many formats like chart, graphs list and in tabular, etc. Reports are based on one dataset or one business unit data for example reports of a store belonging to California.
https://www.educba.com/power-bi-dashboard-vs-report/
HOTSPOT (Drag and Drop is not supported)You have a Power BI report.For each of the following statements, select Yes if the statement is true. Otherwise, select No.Note: Each correct selection is worth one point.Hot Area:
Box 1: YesIf you'd like to see the data that Power BI uses to create a visualization, you can display that data in Power BI. You can also export that data to Excel as an .xlsx or .csv file. The option to export the data requires a Pro or Premium license and edit permissions to the dataset and report.Note: Export data from a Power BI dashboard1. Select the ellipsis in the upper-right corner of the visualization.2. Choose the Export data icon.3. Power BI exports the data to a .csv file. If you've filtered the visualization, then the app will filter the downloaded data.4. Your browser will prompt you to save the file. Once saved, open the .csv file in Excel.Box 2: NoUnderlying data: Select this option if you want to see the data in the visual and additional data from the model (see chart below for details). If your visualization has an aggregate, selecting Underlying data removes the aggregate. When you select Export, Power BI exports the data to an .xlsx file and your browser prompts you to save the file. Once saved, open the file in Excel.Box 3: YesA KPI dataset needs to contain goal values for a KPI. If your dataset doesn't contain goal values, you can create them by adding an Excel sheet with goals to your data model or PBIX file.Note: A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal.
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi
You create a Power BI dashboard that displays data from Dynamics 365 Customer Engagement. You need to share the Power BI dashboard with coworkers.What are three possible ways to achieve the goal? Each correct answer presents a complete solution.Note: Each correct selection is worth one point.
Answer(s): A,B,E
A: Basic Sharing for Dashboards and Reports through a workspace is the most common way of sharing the Power BI content. Basic Sharing is very simple and easy to use method. You can simply click on the Share button in the dashboard or report, and then share it with other users.B: Apps are great sharing method for multiple environment, and best way of sharing for users in production environment.Power BI App is the solution for multiple environment approach. With Power BI App, your development environment (workspace), and user environment (App) are isolated from each other.Note: If you are using SharePoint online as a portal for document management and some other reasons already, then consider using Embed in SharePoint Online feature of Power BI reports. This method is secure and you can share the report only with Power BI users you want.E: Sometimes, you don’t need a secure way of sharing, you may search for an easy and free way of sharing, and your content is not confidential or sensitive. Publish to web is your friend in such situation. This is the only free way of sharing in Power BI, but be aware that this method is not secure.Publish to web method, gives you an embed code, which you can use in any web pages to embed the Power BI report in it
https://radacad.com/power-bi-sharing-methods-comparison-all-in-one-review
Your company has an on-premises Microsoft SQL Server database that contains legacy sales data. You must display information from the database in a new Power Apps app.You need to establish a secure connection between the database and the app. What should you use?
Answer(s): C
For an on-premises database, identify a data gateway that was shared with you (or create one).Specify Connect using on-premises data gateway, type or paste the server name, the database name, the user name, and the password for the database that you want to use, and specify the authentication type and the gateway.
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-azure-sqldatabase
Post your Comments and Discuss Microsoft PL-900 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the PL-900 content, but please register or login to continue.