Powerbi - Study guides, Class notes & Summaries

D (Visual2 and Visual5) You plan to embed multiple visualization in a public website. Your Power BI infrastructure contains the visualizations configured as shown. Visual1; characteristic: Uses row-level securitv (RLS) Visual2; characteristic: Uses a dataset that is stored in Microsoft OneDrive for Business Visual3; characteristic: Contained in a report that was shared to your user account Visual4; characteristic: Is a custom visual Visual5; characteristic: Uses a dataset from an on-premis...

PowerBI CERTIFICATION EXAM 2025 | QUESTIONS WITH VERIFIED ANSWERS (GRADED A+) If you want your data to automatically refresh as you interact with visualizations, which option should you choose? A) Import B) DirectQuery - ANSWER - B) DirectQuery Explanation: When you use DirectQuery, no data is imported into Power BI Desktop. As you create or interact with a visualization, PowerBI Desktop queries the underlying data source, i.e. you're always viewing current data. How do you conne...

What are some of the data sources you can use in PBI? Flat files & Folders (csv, text, excel, json, etc). Databases (SQL Access, Oracle, IBM, MySql, etc.). Power Platform (Dataflows, Power BI Datasets, Datavers3, etc). Azure (SQL Db, Blob Storage, Cosmos DB, Data Lake Storage, etc). Online Services (Sharepoint, Github, Dynamics 365, Google Analytics, Salesforce, etc). Others (web feeds, R scripts, Spark, Hadoop, etc.). What let's you shape and transform data? Query editor What is Po...

PowerBI Certification Exam | Questions with 100% Correct Answers | Latest Update 2024 | Verified

PowerBI Certification Exam 2023 Verified 100%

You plan to get data for a Power BI dataset from flat files. You need a location type to store the files. The date must NOT automatically synchronize between the original file and the dataset. Which location type should you recommend? Local File The local file option will result in importing the file contents without providing automatic synchronization between the original file and the dataset. SharePoint - Team Sites, personal OneDrive accounts, and OneDrive for Business provide the abili...

PowerBI Certification Exam (2023) | Questions & Answers (Graded A+) PowerBI Certification Exam (2023) | Questions & Answers (Graded A+) If you want your data to automatically refresh as you interact with visualizations, which option should you choose? A) Import B) DirectQuery - ANSWER - B) DirectQuery Explanation: When you use DirectQuery, no data is imported into Power BI Desktop. As you create or interact with a visualization, PowerBI Desktop queries the underlying data source, i.e. ...

PowerBI Certification Exam 2023 Verified 100% If you want your data to automatically refresh as you interact with visualizations, which option should you choose? A) Import B) DirectQuery B) DirectQuery Explanation: When you use DirectQuery, no data is imported into Power BI Desktop. As you create or interact with a visualization, PowerBI Desktop queries the underlying data source, i.e. you're always viewing current data. How do you connect to Excel files that contain target figures? T...

PowerBI Certification Exam 2023 Verified 100% If you want your data to automatically refresh as you interact with visualizations, which option should you choose? A) Import B) DirectQuery B) DirectQuery Explanation: When you use DirectQuery, no data is imported into Power BI Desktop. As you create or interact with a visualization, PowerBI Desktop queries the underlying data source, i.e. you're always viewing current data. How do you connect to Excel files that contain target figures? T...

If you want your data to automatically refresh as you interact with visualizations, which option should you choose? A) Import B) DirectQuery - B) DirectQuery Explanation: When you use DirectQuery, no data is imported into Power BI Desktop. As you create or interact with a visualization, PowerBI Desktop queries the underlying data source, i.e. you're always viewing current data. How do you connect to Excel files that contain target figures? The solution should involve minimum manual work...