What is the minimum number of Power BI datasets needed to support the reports?
What is the minimum number of Power BI datasets needed to support the reports?
To support the requirements of the reports, the minimum number of Power BI datasets needed is two imported datasets. This is because analysts need the capability to create new reports from the dataset containing the profit and loss data, while they are restricted from making new reports using the balance sheet data. The use of imported datasets is preferred to avoid the limitations associated with DirectQuery, such as restricted Power Query transformation features and unavailability of certain DAX functions. Hence, two separate imported datasets are needed to adhere to the different permission settings and the reporting requirements.
Take a rest boys, we earned it.
Take a rest girls, we earned it.
Take a rest girls & women :) We earned it ! Oh the answer is A
Why A?
Yet to give Exam, will rest after that
No body comes here to comment after giving the EXAM, until unless you failed it.
But, but, I am starting from reverse.
waaaajajajajajajajajajaja
Finger crossed for every one. Good luck with exam <3. and thank yuo to every one who helped with anserws.
i'm crying rn
It's already stated correctly in the given answer. "Analysts must be able to create new reports from the dataset that contains the profit and loss data" "Analysts must NOT be able to make new reports by using the balance sheet data" Due to this different permissions you need 2 datasets. Import mode.
You can have multiple options. A single imported dataset can meet the requirements as well. P&L is Azure SQLDB - normally DirectQuery. If there is an option - one DirectQuery and one import will be more appropriate.
Hi All, I have passed an exam with score nearly 900 points. Most of the questions were from this site. Exam 01.12.2023 Good luck all !!!
I just came back from the exam. Just scrapped through with around 800 points (transcript not available yet, just a screen flashing at the end of the exam). I'd said most if not all of the questions were from this website (don't ask me which one because I forgot them right away after the exam except for one question which I remember because I was struggling with it and that was the one that you have to merge 5 or 6 different database tables together(Managers/RegionManager etc...), I spent a lot of times on this question so make sure you put extra attention on it! The rest were easy! There were 48 questions and one scenario question. Good luck to all and thank you to all that went through it and left your valuabe feedbacks on this site! Cheers!
my brain is fried did all the questions in 3 days have exam tomorrow let's see.
All the best, Kings! We got this...
Guys and girls, we finally made it. I just passed with 917/1000. Save your time and learn and memorize all these questions because 85% of the 50 exam questions were exactly the same as here. Cheers and goodluck!
Went through the questions in the last three weeks but only once, passed exam today 800+. Truly appreciate everyone who input in the comments section, I almost learned everything about this exam from each of you. Wish you all good luck!
I have my exam tomorrow, gone through these questions 3 times, 4/5/6 times for the ones I got wrong. Will update how I go tomorrow.
Hi, Just an update. I got 958/1000 but was hungover af and not feeling my best. Every single question bar 1 was from these 250 questions. Guys it was so easy, finished it in 30 minutes. The most important thing is to know these questions BY HEART! know every single answer (or at least a decent amount of them) and you will be fine. The questions are exactly the same. Obviously read the comments and don't go by what this website says it is.
Thank you for this update! I'm taking my exam this week or the next one
Hey guys! I just got 906/1000. There was about 10 questions that wasn't from here, 1 case study and 2 different sequence questions that use the same scenario, both from here. The language was a bit different as well, like sematic dataset/data model. Advise: know the answers here, I mean, learn them not only memorize it because you going to need it for the other questions that are not from here.
I'm wishing all of you who are taking the exam eventually, that you all pass! I'm taking mine still this year, I just finished all the questions and now it's revision and practice time again and again. I'll get back after the exam to give some feedback on how was it and what should we expect. Thank you so much to all the community here for helping in all the questions :) Take care!
Tomo is my exam....!
B correct. In this workspace includes two imported datasets: + Dataset for Ending Balance with Dataset Permission as Read --> Cause analysts are not allow to make report. only read and view dat. Mode: Imported. + Dataset for Profit & Loss with Dataset Permission: Build, cause analysts have to make report on this dataset. Mode :imported
If I studied all the questions carefully and know all the answers by heart, will I pass the exam for sure?
let us know
The minimum number of Power BI datasets needed to support the reports is B. two imported datasets. Reasoning: 1. One dataset for balance sheet and product catalog data. This dataset can be accessed by all analysts. 2. Another dataset for profit and loss data. This dataset needs to be filtered by business unit, so it should be separate to allow for row-level security. This will ensure that analysts can only access the data of their respective business unit.
Hints from the wordings in security requirements "Analysts must be able to create new reports from the dataset that contains the profit and loss data" Use of relative clause for dataset implies there are more than one datasets
PnL and BS data must be separated because of the different sharing settings.
we can have 1 dataset and 2 sources.