Minimum no of Datasets and storage mode

[gayathrispark]

What is the minimum number of datasets and storage modes required to support the reports?

[gayathrispark]

Thank u so much

[ribisht17]

You are welcome :), please mark the question as the correct answer so that it can help others as well

Ritesh

[ribisht17 · Accepted solution]

SharePoint and Dynamics 365 Business Central don't support Direct queries, SO not B nor C. And if we choose import mode, "an Import model can integrate data from any number of supported data source types"(https://docs.microsoft.com/en-us/power-bi/connect-data/service-dataset-modes-understand). So the answer is D.

[ribisht17]

@gayathrispark 

1. Even one table within a sheet is enough to start with/ One Data-source with One Table

2. You set the Storage mode property to one of these three values: (so the answer is One)

• Import: Imported tables with this setting are cached. Queries submitted to the Power BI dataset that return data from Import tables can be fulfilled only from cached data.

• DirectQuery: Tables with this setting aren't cached. Queries that you submit to the Power BI dataset—for example, DAX queries—and that return data from DirectQuery tables can be fulfilled only by executing on-demand queries to the data source. Queries that you submit to the data source use the query language for that data source, for example, SQL.

• Dual: Tables with this setting can act as either cached or not cached, depending on the context of the query that's submitted to the Power BI dataset. In some cases, you fulfill queries from cached data. In other cases, you fulfill queries by executing an on-demand query to the data source.

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

[gayathrispark]

What is the minimum number of datasets and storage modes required to support the reports?
A . two imported datasets
B . a single DirectQuery dataset
C . two DirectQuery datasets
D . a single imported dataset