Forum Discussion
Solved
Adding second excel file in a dataflow gives error 'Invalid credentials'
We are using the datasource 'Excel-folder' to add Excel files on a one-drive folder to the dataflow. We have added the one-drive folder as datasource in the gateway. Adding the first excel file in th...
Microsoft logged a bug with number 317350811. Haven't seen the status of this issue. Workaround is creating separate data connections in the gateway for each Excel file
Hi, we are experiencing the same issue with Excel sources and Dataflows.
Only 1 query, it's ok... when we add the second query, we got the Invalid Credential Issue.
Our Excel source is on our internal Network (no sharepoint), so the Gateway is required.
Microsoft logged a bug with number 317350811. Haven't seen the status of this issue. Workaround is creating separate data connections in the gateway for each Excel file
I would like to upvote and downvote this at the same time. A truly miserable workaround ...
