Permission & Access Issues

Fix Power BI Dataflow Access to a SharePoint Folder

Elise WilliamsElise Williams Nov 18, 2026 870 views

Question details

Allow SharePoint Members to connect a Power BI dataflow to a SharePoint folder without granting them Full Access.

Fix Power BI Dataflow Access to a SharePoint Folder
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.
Before you start

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.

Solution 1Recommended

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.

1
Test access in SharePoint

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.

2
Review site and file permissions

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.

3
Use the site URL

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.

4
Check connection credentials

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.

5
Escalate if access still fails

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.

Check SharePoint Access and the Dataflow Connection
Full Access is not the only question to investigate: Full Access may make the connection work, but the exact minimum permission depends on the site, file permissions, and connection setup. Avoid granting it broadly without an administrator's review.
Free Microsoft Office alternative

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.

Review and edit spreadsheet files used in reporting workflowsOpen and save Microsoft Excel formats such as XLSXUse a familiar interface for everyday document workMove existing Office files to a lightweight, free office suite
microsoft office alternative - wps office

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.