Hi all - first post - any help would be greatly appreciated.
I can connect to an Azure SQL DB from my desktop using SSMS / Power BI using "Azure AD - Password". I can publish reports to the PBI service and they refresh automatically fine.
However, I'm struggling to connect to that same SQL DB directly from Power Automate. I'm assuming that Azure AD - password it's where the challenge is - does anyone have any pointers they can give me on whether I can connect to that DB from Power Automate using Azure AD - Password authentication?
Many thanks