Specifies the Premium Power BI workspace(s) to connect to, using a comma-separated list of workspace names.

Data Type

string

Default Value

""

Remarks

This property is useful for narrowing the scope of queries to specific workspaces, optimizing performance, and focusing on relevant datasets. Use a comma-separated list of workspace names, ensuring they exactly match the case-sensitive names displayed in Power BI. Only Premium Workspaces are supported; standard workspaces are not compatible.

To find workspace names in Power BI, follow these steps:

1. Log in to Power BI.
2. Navigate to the Workspaces section in the left-hand panel.
3. Locate the exact name of the Premium Workspace(s) you want to connect to.
4. Use these names in the property configuration, ensuring they match exactly.

If no value is specified, the driver attempts to connect to all Premium Workspaces accessible to the user. While this can be helpful for exploring datasets, it may increase processing time due to the additional requests required to retrieve objects from all workspaces. For example, to connect to two Premium Workspaces named SalesAnalysis and MarketingReports, set the property as follows:

Workspace=SalesAnalysis,MarketingReports