The Power BI workspace and dataset to use.

Data Type

string

Default Value

""

Remarks

The adapter combines each Power BI workspace and dataset into a single catalog name. For example, if you have a workspace called MyWorkspace and a dataset called MyDataset then its catalog name will be MyWorkspace_MyDataset.

By default the adapter will report all workspaces and datasets as separate catalogs. A query can either use the catalog directly, or leave off the catalog to have the adapter search for a matching table.

-- Use this specific catalog
SELECT ... FROM MyWorkspace_MyDataset.Model.MyDimension

-- Search for a catalog containing this table
SELECT ... FROM Model.MyDimension

However, if you have enabled UseMDX then you may want to set this value so that MDX queries go to the correct workspace and dataset. The adapter cannot determine the workspace and dataset automatically from an MDX query.