Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
SteveD2
Resolver I
Resolver I

Dataflow: Trouble with uploading Excel files and folders

Hi,

I've seen an increase in the discussion on the use of Dataflow so, I thought I would give it a try with what I thought would be simple examples of importing an excel file and a folder to see what it's like. The first problem I found is although I worked out that a gateway is required, it has to be the On-premises version and not the personal gateway... the documentation on this really needs to be improved.

The next issue I face is now connecting to the file through the gateway. No matter what I've tried, I continue to get this error.

SteveD2_0-1572388547686.png

Suggestions on what I'm doing wrong would be appreciated.

1 ACCEPTED SOLUTION
SteveD2
Resolver I
Resolver I

Ok, I found out how to do this through some trial and error. For those that may be interested, here's how you access files on your PC using Dataflow.

  1. Download Power BI Gateway and install using the "On-Premises" version.
  2. Sign in to the On-Premises Gateway using your windows username and password (not your Power BI/O365 credentials)
  3. In the Power BI Service, navigate to the workspace where you want to create a Dataflow and create a new entity.eg Create\New Entity\Excel file.
  4. Make sure your data source resides on your PC. Dataflow won't accept a sync/online version of a file or folder. If using Onedrive make sure the file is marked as "Always keep on this device". and;
  5. Select your gateway and enter your windows username and password as per your windows account.

View solution in original post

1 REPLY 1
SteveD2
Resolver I
Resolver I

Ok, I found out how to do this through some trial and error. For those that may be interested, here's how you access files on your PC using Dataflow.

  1. Download Power BI Gateway and install using the "On-Premises" version.
  2. Sign in to the On-Premises Gateway using your windows username and password (not your Power BI/O365 credentials)
  3. In the Power BI Service, navigate to the workspace where you want to create a Dataflow and create a new entity.eg Create\New Entity\Excel file.
  4. Make sure your data source resides on your PC. Dataflow won't accept a sync/online version of a file or folder. If using Onedrive make sure the file is marked as "Always keep on this device". and;
  5. Select your gateway and enter your windows username and password as per your windows account.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors