Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.