Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Here's the issue.
1. Create a new dataflow
2. Select "Add new entities" and choose SQL Server database.
3. Enter in the server and database names, corresponding to a source defined in an on-premise data gateway
4. The dialog autopopulates the stored credentials from the gateway but when you click "Next" you get an error saying:
A workaround that let's you actually connect to the data source is to create a blank query instead and then using the advanced editor type in the connection to the database. Then when prompted by the Dataflow editor to provide credentials it will work.
Seems like a bug with the dialog for creating a new query using SQL Server.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.