latos
0
When connecting using my local gateway, I get this error:
Failed to create connection for connection id '/providers/Microsoft.PowerApps/apis/shared_sql/connections/shared-sql-513a7282-460c-4ad2-bd55-954e83289509'. Multiple errors occurred: ''. Please see details.
I am not able to see the details it is referencing. Is there something I am missing?
Took me some digging but I found the solution.
After you download the data gateway software from Microsoft and set it up with an onmicrosoft.com domain, the missing step is to go in the PowerBI website.
There you check in Settings, Manage Gateways, On-premises data gateways. If your gateway is shown, then the final step is to create a data cluster in Data sources. For some reason, my SQL server login I created in my security did not work, so I decided to use the Windows authentication, as it was easier. Note, if your PC is logged in with a Microsoft account, your login is your computer's domain and password. If it is local, then you put your computer's name (e.x. mine is tams).
After creating the data cluster for the gateway, go back to Power Automate and connect to your local SQL server again. This time, the gateway will appear as an option in the dropdown menu, instead of typing it in. Input your information exactly the same way you did in PowerBI and it should work.