How to Fix Empty Power BI Dataflows Workspace in Excel
Question details
The user is unable to view their Power BI dataflows in Excel because the workspace appears empty during connection.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Connecting Microsoft Excel to Power BI to import dataflows for data analysis and reporting.
- Observed behavior
- Excel displays a completely empty workspace when connecting to Power BI dataflows, even though the dataflows are visible and accessible in the online Power BI service.
Ensure you have a stable internet connection and verify that you are signed in to both Excel and the Power BI service using the exact same organizational account.
Verify and Switch Organizational Account Credentials
This is the most common fix. It ensures Excel is using the correct account that has explicit permission to view the Power BI workspace.
Excel often caches account credentials, meaning it might try to connect to Power BI using an alternate or personal account instead of your authorized organizational account.
Open Excel, click on 'File' in the top-left corner, and select 'Account' from the bottom-left menu. Note the user email signed in under 'User Information'.
If the account does not match the one used for Power BI, click 'Sign out', then click 'Sign in' and enter the correct organizational email and password.
Navigate to the 'Data' tab on the ribbon, click 'Get Data', select 'From Power Platform', and choose 'From Power BI dataflows' to see if the workspace now populates.

Clear Data Source Permissions Cache
Use this solution to force Excel to prompt you for your credentials again by clearing previously saved, potentially invalid connection settings.
Create a Test Dataflow to Isolate the Issue
This helps determine whether the issue is specific to a single corrupted dataflow or if it affects the entire workspace.
Try WPS Office for Seamless Data Management
While the Power BI dataflow connection is a Microsoft-specific feature, WPS Office provides an incredibly powerful, lightweight, and free alternative to Excel for all your standard data processing, chart creation, and analytical needs.
- 1. Download WPS Office: Visit the official WPS website and download the free version of WPS Office for your operating system.
- 2. Install the application: Run the installer and follow the on-screen instructions to set up the software in seconds.
- 3. Open your datasets: Launch WPS Spreadsheet and open any existing Excel workbooks or CSV data exports to analyze your data immediately.

Frequently Asked Questions
Why can I see the dataflow in Power BI online but not in Excel?
This usually happens due to mismatched account credentials. Excel might be logged in using a different account than the one you use for the Power BI web service, or the Excel cached credentials have expired.
Do I need a special license to connect Excel to Power BI dataflows?
Yes, to access Power BI dataflows in Excel, you must have an active Power BI Pro or Premium license, and you must have at least 'Viewer' access to the workspace where the dataflow resides.
Does clearing data source permissions in Excel delete my actual data?
No. Clearing data source permissions only removes the saved login credentials and connection rules from your local Excel application. It forces Excel to ask for your username and password the next time you connect.
What is the difference between Power BI Datasets and Dataflows in Excel?
Datasets are fully modeled data ready for pivot tables and reporting, whereas Dataflows are data preparation processes that allow you to import raw or transformed tables into Excel via Power Query for further manipulation.




