Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dataset not visible in Excel/Power BI Desktop

Hi all,   We're trying to give users access to a dataset so they can view the reports in an App but also Analyze in Excel and/or build reports. This is our setup in Power BI Service:   Workspace...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    An update on this. We've finally managed to set this up correctly.

     

    The security group XY needs to be added to the "Use datasets across workspaces" tenant setting as this setting is enabled for a subset of our organization.

     

    We had added the security group to the "Allow Live Connections" tenant setting, but not to the "Use datasets across workspaces" one.

     

    Good finding for a Friday

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

An update on this. We've finally managed to set this up correctly.

 

The security group XY needs to be added to the "Use datasets across workspaces" tenant setting as this setting is enabled for a subset of our organization.

 

We had added the security group to the "Allow Live Connections" tenant setting, but not to the "Use datasets across workspaces" one.

 

Good finding for a Friday