Fix Power BI Dataflow Access to a SharePoint Folder
Question details
Allow SharePoint Members to connect a Power BI dataflow to a SharePoint folder without granting them Full Access.

- Product
- Power BI Service and SharePoint Online
- Device & OS
- not provided
- Scenario
- A user creates a Power BI dataflow that connects to files in a SharePoint folder.
- Observed behavior
- Site owners with Full Access can connect, but users with Member or Edit permissions cannot view or filter the folder resources.
Identify the affected user, the SharePoint site URL, and a file the dataflow needs to access. Confirm that the user is signed in with the intended organizational account in both SharePoint and Power BI.
Check SharePoint Access and the Dataflow Connection
Use these checks to identify whether the connection URL, credentials, or permissions are preventing a Member from accessing the folder.
Have the affected user open the SharePoint site in a browser, navigate to the target folder, and open a required file. If editing is needed for the workflow, also confirm that the user can edit it.
Ask a SharePoint administrator to open Site permissions for the site and Manage access for the target folder or file. Check whether unique permissions restrict the affected user, even if the user is a site Member.
In the Power BI dataflow editor, select the SharePoint folder connector and enter the root site URL, such as https://contoso.sharepoint.com/sites/Finance, rather than a folder or file URL.
When prompted by the connector, sign in with the affected user's organizational account and retry the connection. In the data preview, look for the required files and filter the folder path.
If the user can access the file in SharePoint but the dataflow still fails, give the SharePoint or Microsoft support team the site URL, affected account, error details, and the result of the Full Access test. Ask them to identify the least-privileged permissions needed for the connection.

Work With SharePoint Spreadsheet Files in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working on Office documents and spreadsheets. Its format support makes it easy to move existing files into WPS, though it does not fix Power BI or SharePoint permission issues.

Frequently Asked Questions
Why can a SharePoint owner connect when a Member cannot?
The accounts may have different access to the site, folder, or files. A SharePoint administrator can check Site permissions and the folder or file's Manage access settings for restrictions.
Should I enter the SharePoint folder URL in the Power BI connector?
For the SharePoint folder connector, try entering the root site URL, such as https://contoso.sharepoint.com/sites/Finance. After connecting, filter the available files by their folder path.
Do Members need Full Access to create a dataflow?
Not necessarily. Full Access may resolve this particular symptom, but the minimum required permissions depend on the connection and SharePoint configuration. Ask a SharePoint administrator or Microsoft support to review the least-privileged option.
What should I check if I can open the file but the dataflow still fails?
Check that the SharePoint folder connector uses the correct site URL and that its credentials belong to the intended organizational account. If it still fails, provide the error and test results to SharePoint or Microsoft support.




