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

     

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
5 years ago

Hi Anonymous 

 

Could you go into the underlying dataset and verify that the required users have the permissions for build on the dataset level?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi GilbertQ ,

 

Thank you for your answer. Yes, we've added a security group that contains the users with read and build permissions on the underlying dataset. This is working as the users can see the reports and the data from the App and, also, they can use the Analyze in Excel feature in the report which would indicate the Allow Live Connection tenant setting is set up correctly.

 

The issue is the dataset is not available when they try to access it from Power BI Desktop or Excel.

 

Ricardo