cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

excel dataflow filepath setup issue

When I try to add a dataflow from an excel file the next button is greyed out and the autorization kind is anonymous which it should be and my only option. I have found through testing that power bi does not allow a letter to be in the beginning of the filepath and I don't understand the criteria they want. My filepath looks like this: C:\Users\Name\Folder\file.xlsx what am I doing wrong? I have already tried deleting the C: and C:\ before the path but it gives me a "path is invalid" message.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: excel dataflow filepath setup issue

Hi there

Yes I totally forgot because dataflows are a cloud based service, if you are connecting to any file that is not cloud sourced, you would need the Gateway to connect to the file.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

5 REPLIES 5
Highlighted
Super User IV
Super User IV

Re: excel dataflow filepath setup issue

Hi there

Would it be possible to store it in OneDrive for Business, then you can access the file via that Copy Path option?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Highlighted
Helper I
Helper I

Re: excel dataflow filepath setup issue

We don't use onedrive but there isn't an option for adding a link for onedrive. I tried adding the onedrive link to the excel option but I am getting error messages and same with adding the link to the sharepoint option.

Highlighted
Super User IV
Super User IV

Re: excel dataflow filepath setup issue

Hi there,

I would need to then try it out myself and see why it is not working.

Another question is your Gateway available to you?

If you are connecting to a local file, you would need to use the Gateway in order to connect to the local file?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Highlighted
Helper I
Helper I

Re: excel dataflow filepath setup issue

This would bring me back to original problem where pasting in the local file path ex: C:\Users\Name\Folder\file.xlsx gives me no option to choose a gateway or authentication method. I assume I need to set up a gateway?

Highlighted
Super User IV
Super User IV

Re: excel dataflow filepath setup issue

Hi there

Yes I totally forgot because dataflows are a cloud based service, if you are connecting to any file that is not cloud sourced, you would need the Gateway to connect to the file.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors