Import from OneDrive and SharePoint greyed out

Adding 'useRootUrlFilePicker=0' has made sharepoint and ondrive an option but it then error when trying to find the file so it's still not working.

some of our users are reporting the same now, adding the URL opens up the options in the menu but then they can't connect to any OneDrive or SharePoint sites. It's not affecting all users though which is making any diagnosis difficult

It's so frustrating, we also have an issue trying to add people to connections. It's stuck on loading...Do you have a mix of Power BI licenses? I'm wondering if it's an issue with Power BI Premium Per User maybe as that's what my team have but everyone else is Pro.

we're on F64 and just Pro licenses for the developers. It isn't even consistent there, I'm the Fabric admin and have Pro licence and it doesn't work for me but works for other devs with Pro.

Hi Amizy ,

Glad to see that adding useRootUrlFilePicker=0 enabled the SharePoint and OneDrive options this confirms the workaround is effective.

The error you’re encountering when browsing or locating the file is likely related to file location or permissions. Ensure your PBIX file is stored in the root directory of your OneDrive or SharePoint, not in subfolders or shared libraries, as the picker can have trouble accessing those.

Also, verify you’re signed into Power BI with the same Microsoft account that owns or has full access to the file. If the file is shared or from a team site, that may be causing the issue. Using an incognito/private browser window can help rule out cached login problems.

Lastly, check that SharePoint and OneDrive integration settings are enabled in the Power BI Admin portal.

If you have any future queries, feel free to reach out to me.

Thank you.

I don't think that's the reason, we have used the import sharepoint method for the last 12 months, we have one location for the pbix files and that's the one I am using. I am the Power BI admin so I have all the right permissions etc. I have tried incognito/private browser. I think the issues are related, along with Power BI hanging on 'loading' when trying to add people to a connection.

it's not "effective" as it doesn't allow the same access to files as existed prior to last Monday. You can't really expect users to save all their work in the root folder of SharePoint or OneDrive.

Hi Amizy ,

Since you've already implemented all the recommended workarounds and have full Admin privileges, the most effective next step is to have Microsoft support review the backend.

You mentioned submitting a support ticket have you connected with them or received any updates so far?

Thank you.

Hi Amizy ,

We’d like to follow up on your support ticket. Has the issue been successfully addressed?

If a solution was provided, we’d truly appreciate it if you could share your experience or any relevant details, your input could be valuable to other community members.

Thank you.

Hi v-tejrama I have been speaking to Microsoft they think possibly there's been a policy change in SharePoint 365 admin. I am waiting to speak to someone internally to see if it can be resolved. Once it has and I know the fix I will post 🙂

Hi Amizy ,

Thanks for the update and follow-up much appreciated.

Kindly keep us informed as things progress.

Thank you.