Forum Discussion
Analyze in Excel not available to Users
We created a ticket with Microsoft to investigate. The issue was that one of our security groups was deleted, and a mail-enabled security group was created with the same name. When this happened, the security group remained in-place as a Specific security group under the Allow Live Connections setting in Tenant Settings. We removed this specific security group, and then re-added it and it began to work again.
My best guess is that Power BI was trying to assign permissions to the old security group because it had the same name, but the old group no longer existed. By removing it as a specific security group and then re-adding it, Power BI was able to point the permission to the correct group.
Super UserHi stetson
Have you asked your users to try and connect directly from Excel to Power BI as shown below when using Excel?
You could also try the Excel in the web?
Create Connected PivotTables in Excel for the web | Microsoft Power BI Blog | Microsoft Power BI
This was a good suggestion, and it brought an interesting result. The User can see the dataset as an available option, and when they select it, it populates as a connection under Queries & Connections - however, the data never populates (no pivot table is created) and there is no response from Excel when the user tries to refresh the connection.
It may be worth noting that, as an admin, I am able to perform this as expected.