Forum Discussion
Power Bi and Power Automate - export to csv button not working
Hi all,
I was hoping to get some help or just to know if i am not able to do it with my free licenses. I am trying to create export button with Power Automate (export to csv), but i keep getting this error when i test the flow:
I have free Licenses, not Pro or Premium. Am i just not able to do it because of that or am i doing something wrong? Below are my steps as well. Any guidance would be really appreciated. 🙂
 
Hi Erika_S ,
By my test and reserch, for export data, there is no license requirement, free users can achieve it.
Reference: Export data from a Power BI visualization - Power BI | Microsoft Docs
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
Hope it helps!
Best Regards,
Community Support Team _ kalyjIf this post helps, then please considerAccept it as the solution to help the other members find it more quickly.
10 Replies
Just let me know if you think i am wasting my time 🙂
Hi Erika_S ,
By my test and reserch, for export data, there is no license requirement, free users can achieve it.
Reference: Export data from a Power BI visualization - Power BI | Microsoft Docs
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
Hope it helps!
Best Regards,
Community Support Team _ kalyjIf this post helps, then please considerAccept it as the solution to help the other members find it more quickly.
Yes, it worked on Desktop and in Service. Sadly it is still on available for Sharepoint embded, right?
Hi Erika_S ,
If you mean reports embeded in SharePoint, by my test, it can also be exported successfully, the premise is that it can be exported when it is on the Power BI Service.
Best Regards,
Community Support Team _ kalyj
Hi v-yanjiang-msft,
Do you know if we require PowerBI or/and Automate licenseing for running Power Automate visual on Power BI?
I am having trouble creating an export (csv) button in my Power BI report thru Power Automate visual.
The button will not feed the data from my dynacmic table as it restricted output as {}
Could this be due to the lack of licsensing?
Thank you
Yes, it was the licenses issue. I then went around it by using power automate export function by querying power bi dataset. I know not the same, but worked for my use case.
