Forum Discussion
Helper IPower Bi and Power Automate - export to csv button not working
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.
Community SupportHi 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
Helper II 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
HFTHi Yang,
These are the steps I take.
- Power automate scheduled flow (define your timing)
- 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.)
- Create CSV table. From = first table rows
- Current time
- 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.