Forum Discussion
Solved
Dataflow Gen 2 Error - external policy action was denied
I am trying to load a SharePoint Excel file into a SQL database in Fabric. I created the SQL database as I have admin role in the workspace. I then created a Dataflow Gen 2 using Azure SQL database a...
Glad it helped!! So seems to be more on connection detail issues
When trying to connect using SSMS, I get an error that database 'master' on server xxx is not currently available. The session tracing ID is {8B953507-F12D-49D9-8DD2-F53D98FF8733}, error:40613.
Howerver, using Fabric SQL Editor, I can create a table.
The error you are getting via SSMS is because you have not provided the database name.
Go to the option settings and rather than database name being default, provide your database name.
And can you confirm the connection in dataflow Gen 2 account itslef is being used to login manually and you are able to create the table?