Forum Discussion
Resolver IUpdate Excel file in SharePoint with Power BI dataset
Hi All,
I'm trying to bring some calculated columns from my Power BI dataset and store them in an excel file within sharepoint.
I have created the excel file with the column headers that I want to bring in from Power Bi and I have attempted to set up a Power Automate within Power BI to achieve the goal but it's not working and I'm not sure what I'm doing wrong.
Here is an example of what I have in my flow, bear in mind I'm not sure if the "add row to table" is the correct action, Ideally what I'd do is remove all the data from the excel and update it with the data from power bi
Thanks
Hi obriaincian ，
From your error message, it said "Required properties are missing from object: entity", you can refer to these similar threads: Handling non-existant properties? - Power Platform Community
Parse JSON Schema - Required properties are missin... - Power Platform Community
And you question is about Power Automate,to quickly get answer , I advise you to create a case on Power Automate Forum, they are more specialized when it comes to Power Automate,refer:
https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Best Regards
Lucien
3 Replies
- amitchandak
Super User
obriaincian , Are you looking for export to excel or something else
export to excel
obriaincianamitchandak Thank you for your response unfortunately neither work. I get this Error The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Required properties are missing from object: entity.'
- v-luwang-msft
Community Support
Hi obriaincian ，
From your error message, it said "Required properties are missing from object: entity", you can refer to these similar threads: Handling non-existant properties? - Power Platform Community
Parse JSON Schema - Required properties are missin... - Power Platform Community
And you question is about Power Automate,to quickly get answer , I advise you to create a case on Power Automate Forum, they are more specialized when it comes to Power Automate,refer:
https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Best Regards
Lucien
