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
Thanks for your help. The connection string was incorrect in the dataflow. I was using xxx..datawarehouse.fabric.microsoft.com from the warehouse instead of yyyy.database.fabric.microsoft.com,1433. Also the database name has a GUID appended to the name. I was missing it as well.
I found the correct connection string by going to Open in SQL Server Management Studio. Once those were entered, the dataflow successfully loaded the data.
Thanks,
Bill
Glad it helped!! So seems to be more on connection detail issues