My organisation has been using the "upload .pbix from sharepoint" feature for some time and this was going fine until recently the feature has been greyed out.
The information box says we need a sharepoint license, but that's included in our E3 license right?
When I go to portal.office.com and see what subscriptions I have, I see this:
Do I need more rights for sharepoint uploads? Maybe a setting the admin has to change?
Any help will be appreciated
Hi @maanlander ,
This issue has been submitted internally.
2. Check if disabling useRootUrlFilePicker feature switch works by adding ?useRootUrlFilePicker=0 to the url
Please be patient to wait for fixing. If there is any news, I will update it here.
Recently I had contact with someone with someone from the support egineering team and they said the following:
I had the chance to look internally for this scenario and was able to see that there is currently two possible workarounds to test, so I would like to request you to do this.
- Check if disabling useRootUrlFilePicker feature switch works by adding ?useRootUrlFilePicker=0 to the url
When I add this to my url the button suddenly works:
While this is a workaround, it at least works. So for anyone in the future with this problem, try adding ?useRootUrlFilePicker=0
Hello all, and especially the support team,
Like Ian, about since a month some users experience problems with 'Upload PBIX to Sharepoint or Onedrive' from https://app.powerbi.com: the option is greyed out with a message that a subscription is required, and this was working for them before. We send in a Premium support ticket to the Sharepoint-team as well last week, but no answer as of yet.
Two solutions (O365 license, UseRemoteAPI's) have been tested on Chrome/Edge/Firefox, and the option from the workspace is still greyed out for some users, and the sync to Onedrive has been disabled. All our projects with this method are disrupted.
1. Usergroups have a M365 and Power BI Pro-license. The logged in users are members of the groups. 2. On the site root level and library permission level “Limited Access”, the permission “UseRemoteAPIs” have been set. 3. Granted access to the same user groups as in Power BI and thus propagating RemoteAccessAPI permissions.
Please help, that would be appreciated. Is this a permanent, or a temporary workaround? Syncing PBIX Onedrive, and Sharepoint files to a Power BI workspace is an appreciated functionality.
Its back again today. No issues for past 2 weeks. Had made some changes to the .pbix and was trying to refresh from the workspace and started getting the error not able to authenticate one drive credentials. Deleted the pbix to reupload and ofcourse its greyed out again. Has anyone got any solution to this ?
Wow.. not sure how this works but I think its something to do with getting signed in on the office portal.
Logged in through firefox and confirmed the code through authenticator app and saw the options on Firefox. Then checked back on Edge - its available. 😥 No idea whats happening here.
See the update from the logged issue from @Ian_Altis
OneDrive/ Sharepoint upload greyed out and not wor... - Microsoft Power BI Community
Hi @Ian_Altis ,
After our investigation First of all, this issue is not related to Power BI license or SharePoint license.
Secondly, it cannot be fixed on the Power BI side.
The way you can fix this is by ADDING the UseRemoteAPIs base permission to the Limited Access role definition at the site collection root web level.
For propagating RemoteAccessAPI permissions ：
You need to do this on the Sharepoint 365 side.
If there are additional follow-up questions, please contact the SharePoint support team for further assistance.
Community Support Team_ Caitlyn
Well it works with PRO for me. The same PRO account that is a service account, Offshore team is not able to upload.
Its random though. Days we would see it and some days it shows disabled.
I too am seeing this issue with a client. They are a large organisation and have SharePoint, Teams and a Power BI Pro licences. Very interested in hearing if there is a fix for this or a setting somewhere.
Am seeing the same issue. Pls keep us posted.
I've another PPU account and 've uploaded the .pbix from there. Then through the PRO account which is giving the same issue as yours am taking over the ownership of the dataset. Still need to check if any issues with end users.
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.