Forum Discussion
Solved
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 ...
- 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.
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?
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.
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.