Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
Xaraja
Helper II
Helper II

Add In for PowerPoint with Multifactor Authentication

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.

1 ACCEPTED SOLUTION
Xaraja
Helper II
Helper II

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.

View solution in original post

4 REPLIES 4
Xaraja
Helper II
Helper II

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.

Xaraja
Helper II
Helper II

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.

lbendlin
Super User
Super User

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).

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.