Power BI Datasets

[komengem]

I created a Power BI dataset which I am able to publish to any workspace we have in our tenant.
However, when I create a report using this dataset, I am only able to publish to the workspaces I created. Is this normal behavior? Are there settings i need to configure so that i can publish to any of the available workspaces in our tenant?

[Greg_Deckler · Accepted solution]

@komengem Yes, there is a Tenant setting that allows you to use connections across workspaces. Go to the Admin portal (gear icon in the Service then choose Admin portal) Then click Tenant settings. Under Workspace settings, expand Use datasets across workspaces and enable it.

[komengem]

@Greg_Deckler I went through the settings instructions. It was already enabled. 

[Greg_Deckler]

@komengem Do you have access to these other workspaces? As in Member or Owner? You can only publish to workspaces where you are a Member or Owner.

[komengem · Accepted solution]

@Greg_Deckler I just found out what was limitting me. When the Power BI Tenant was configured, they created all the workspaces using Teams (or Office 365), which means that all the workspaces were classically created. That is why i am not able to share dataset across them. I will be upgrading all the workspaces to make this possible. Thank you for your help @Greg_Deckler.

[Greg_Deckler · Accepted solution]

@komengem Yes, there is a Tenant setting that allows you to use connections across workspaces. Go to the Admin portal (gear icon in the Service then choose Admin portal) Then click Tenant settings. Under Workspace settings, expand Use datasets across workspaces and enable it.