Power Bi and Power Automate - export to csv button not working

[Erika_S]

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. 🙂

 

[v-yanjiang-msft · Accepted solution]

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 _ kalyj

If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.

[y3wan]

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

[Erika_S]

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.

[y3wan]

Thanks Erika_S

I will test it out

[Erika_S]

Yes, it worked on Desktop and in Service. Sadly it is still on available for Sharepoint embded, right?

[v-yanjiang-msft]

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

[Erika_S]

I see. That's with Pro/Premium licenses, is that right?

How about Power Automate export to csv button on Power bi on the Sharepoint embeded. That didnt work for me. Can you let me know if it works for you? 

[v-yanjiang-msft]

Hi @Erika_S ,

Yes, users viewing a report in SharePoint need either a Power BI Pro or Premium Per User (PPU) license or the content needs to be in a workspace that's in a Power BI Premium capacity.

Reference: Embed a report web part in SharePoint Online - Power BI | Microsoft Docs

About Power Automate, can you show me your flow? I'm not very clear about that.

Best Regards,
Community Support Team _ kalyj

[HFT]

Hi Yang,

These are the steps I take.

1. Power automate scheduled flow (define your timing)
2. PowerBI connector, run a query against a dataset. Identify your workspace and dataset. For the query (To get the query, I go to PowerBI Desktop > navigate to the page/visual > View > performance analyzer > start recording > refresh visuals > let it run > stop. Select your visual of interest and expand. Copy the dax code. This is what goes back into the query box in #2.)
3. Create CSV table. From = first table rows
4. Current time
5. send an email(v2), where in i am able to get the mail but the whole data is coming in first row, i want the attachment to get the data clearly as how it is in power bi dataset table visual.

[Erika_S]

Just let me know if you think i am wasting my time 🙂