I would like to create a report in power bi from a cognito form assessing employee engagement in my workplace.
I can create the report myself, but I cannot work out how to get the data to link to power bi.
The flow in power automate is as follows -
entry is created in cognito - new entry is created in a spreadsheet - this data should then update in power bi
there is also a spreadsheet with a headcount of the office and a pivot table which outlines how many responses we get from each division.
I have attached an image of the cognito form, the 2 spreadsheets and the flow I created.
Please help me connect these flows!