You’re offline. This is a read only version of the page.
Announcements
Hello everyone,
I want my PowerBI report ,which should be able to refresh its dataset when a new item is created in SQL database table. For this i have used power automate. First i have used push dataset to groups api and mentioned the table format in json. Then created a database table in that name. then a dataset is created in my powerbi workspace. Next in Power automate , I used automated flow for this, I named the flow. Then used SQL when a item is created as a trigger, then in actions. The sql connection is performed with mentioning the server name, username, password and data gateway. The data gateway i used is the one which i created in the powerbi environment. Then in action i choose refresh a powerbi dataset. then i had given the workspace, table and dataset. Also i mapped the column name to their respective ones. When i click the test manually. I added a new record in the database. But it is not refreshing in the dataset.
what may be the reason?
Share
Report
All responses (
Answers (
8,479
