Forum Discussion

Regular Visitor

1 year ago

Solved

Import from OneDrive and SharePoint greyed out

Hi, I am not sure if this is a setting in the admin portal or if something odd is going on but my team noticed yesterday that the option to import a power bi file from one drive/sharepoint is gre...

Amizy
1 year ago
AndyBurnsNHS it turned out to be an internal IT policy that was changed! Option is now not greyed out but can't access the sharepoint site....Assume another policy needs to be looked at. It's been a rather frustrating and long process!

Regular Visitor

1 year ago

BhavinVyas3003 thanks Bhavin, I am an admin but i can't see anything in the portal for switching on integrations (everything was working as of last week, i've not made any changes) Do you know which setting it is? Thanks

BhavinVyas3003
Super User
1 year ago
You can enable the feature in the Power BI Admin portal. Set new Users can view Power BI items saved in OneDrive and SharePoint (Preview) setting to Enabled. The setting is under Tenant settings > Integration settings.

Also please refer these blogs,

https://powerbi.microsoft.com/en-us/blog/pre-announcing-better-power-bi-report-integration-with-onedrive-and-sharepoint-preview

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-sharepoint-viewer
- Amizy
  Regular Visitor
  1 year ago
  BhavinVyas3003 the setting is already enabled
AndyBurnsNHS
Regular Visitor
1 year ago
same has happened for us since yesterday, tenant settings are enabled but no users can import from OneDrive or SharePoint even Admins
- Amizy
  Regular Visitor
  1 year ago
  AndyBurnsNHS it looks like there was a similar issue in 2023, I've tried the two workarounds but didn't change anything for me:
  https://community.fabric.microsoft.com/t5/Issues/OneDrive-Sharepoint-upload-greyed-out-and-not-working-in-some/idi-p/3161241
  - AndyBurnsNHS
    Regular Visitor
    1 year ago
    adding the useRootUrlFilePicker=0 option to the url has worked for us