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??
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Share
Report
All responses (
Answers (
525
