Power Platform Community Forum Thread Details

I am trying to create a flow using SQL server. I selected "Automated Cloud Flow" > selected 'Item Modified SQL Server ' > Added Server, Database and Table name (credentials have no errors) > Added Power BI as connector and chose Trigger - Refresh dataset > Selected workspace and dataset > Save > I get this message:

I have verified the credentials work, the report refreshes successfully in Power BI service that is connected to a on prem data gateway. The account permissions has 'read only'. What am I doing wrong, missing??

Categories:

Using connectors