Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have a request from users to use the feature in Power BI to embed live data from Power BI in a PowerPoint presentation. They are getting the message "Microsoft 365 has been configured to prevent individual acquisition of Office StoreAadd-ins". I had our Exchange admin go through the Centralized Deployment steps (found here) and tested it, but it still isn't working for me. I checked the instructions again a bit more carefully and realized that centralized deployment of add-ins doesn't work for environments with multifactor authentication. Has anyone found a way to provide access to the "embed live data" option in Power BI in a corporate environment with multifactor authentication? It's not an option to just allow everyone to add any add-in they want or turn off multifactor authentication. This seems like a large oversight if not so I'm hoping I'm just missing something.
Solved! Go to Solution.
I did some more searching and found that the issue in our case was in the registry on the machines themselves. Although we are using Office 365, this link discussing Office 2016 worked. https://admx.help/?Category=Office2016&Policy=office16.Office.Microsoft.Policies.Windows::L_DisableO... This link is discussing how to block the Office Store, but we found that the registry setting it discusses was entirely missing from the registry for our machines, and the default setting is to allow the Office Store, so all we had to do was to create the registry setting. Oddly, although we are using Office 365, creating the registry for Office 16 worked fine.
This had to be done in concert with the Centralized Deployment discussed in the Microsoft documentation (https://docs.microsoft.com/en-us/microsoft-365/admin/manage/centralized-deployment-of-add-ins?view=o...). Once the add-in was deployed through Centralized Deployment (in the admin center) and the registry was updated, the add-in worked as desired.
I further found that once the registry setting had been created on my machine, I could export it as an .exe and then use that to update the registry on my user's machines. Fortunately, in our environment this is possible - I imagine many other environments would not allow such registry editing.
Hopefully if someone else comes across this issue this will assist them.
I did some more searching and found that the issue in our case was in the registry on the machines themselves. Although we are using Office 365, this link discussing Office 2016 worked. https://admx.help/?Category=Office2016&Policy=office16.Office.Microsoft.Policies.Windows::L_DisableO... This link is discussing how to block the Office Store, but we found that the registry setting it discusses was entirely missing from the registry for our machines, and the default setting is to allow the Office Store, so all we had to do was to create the registry setting. Oddly, although we are using Office 365, creating the registry for Office 16 worked fine.
This had to be done in concert with the Centralized Deployment discussed in the Microsoft documentation (https://docs.microsoft.com/en-us/microsoft-365/admin/manage/centralized-deployment-of-add-ins?view=o...). Once the add-in was deployed through Centralized Deployment (in the admin center) and the registry was updated, the add-in worked as desired.
I further found that once the registry setting had been created on my machine, I could export it as an .exe and then use that to update the registry on my user's machines. Fortunately, in our environment this is possible - I imagine many other environments would not allow such registry editing.
Hopefully if someone else comes across this issue this will assist them.
Are you referring to "Turn on optional connected experiences"? That's the only toggle I'm finding in the Trust Center and unfortunately it's already turned on.
Yes, that's the one. No idea what else could be the culprit.
We had something similar and had to enable a "allow extra features" setting deep in the bowels of the Office options trust center settings, privacy area. Give that a try (after reading the fineprint).
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
4 | |
4 | |
3 | |
3 | |
3 |