Forum Discussion
Dataflow Gateway brings wrong table
I found the reason.
It's not possible to do it. It's a limitation of dataflow. Period.
"Dataflows using gateway data sources do not support multiple credentials for the same data source"
https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-features-limitations
You have precisely described my issue.
I'm experiencing this with on-prem SQL Server. I have two different SQL logins with separate access privileges to different tables.
I want to create two dataflows that use specific logins on the same server and database. I cannot select a login to use with a particular dataflow. When I enter credentials for one of them the other breaks and throws "The key didn't match any rows in the table". It makes sense because it has changed the previous setting and now it cannot see the table.
Creating different data source in gateway configuration didn't help either. It looks like you can select credentials in gateway config but it has no effect.
I'm thinking about using server alias or IP to differentiate the server definition in gateway configuration, which seems to be an overkill.
Please update, if you have found a solution.
Thanks,
I found the reason.
It's not possible to do it. It's a limitation of dataflow. Period.
"Dataflows using gateway data sources do not support multiple credentials for the same data source"
https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-features-limitations