Can we provide more than one dataset id in dataset binding (App owns data)

[Anonymous]

Hi Community,

We have implemented an embedded solution using dynamic binding successfully using Power BI App Owns Data available in Github.

My question here is can we provide multiple datasets using Dynamic binding.

datasetBinding: {
		datasetId: "notOriginalDatasetId", // The wanted dataset id
	}

 let say here can we provide like below?

datasetBinding: {

                            datasetId1 :"12345678",

                            datasetId2: "78654321",

           }

And if it true, what should we need to change in the code??

Please help me to solve this.

Thanking You.

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Please refer to this.

The datasets that you select need to use the same data schema. But if you have multiple datasets with the same data schema, your report can connect, or bind, dynamically to each of those datasets. You can then display different insights, depending on your needs.

Bind datasets dynamically to a Power BI embedded report in Power BI embedded analytics | Microsoft Docs

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[CVance]

Hi @Anonymous ,

Each report is limited to a single dataset. The dataset can have multiple data sources, but they must all feed into a single dataset. If you need multiple datasets, then you should be using a Dashboard. A Dashboard is comprised of multiple reports. 

A workspace can have multiple datasets, but a report must have at most one dataset. You can have multiple reports all relying on a single dataset (live connection), but that still follows the rule: each report can have only 1 dataset.

Be careful if you use a shared dataset for multiple reports. This scenario prevents you from creating paginated reports, and paginated reports are the only way to export to Excel.