Ability to Export Data In Format Other than xlsx or csv?

[kewaynes]

I know that users can export data from visuals in the format of xlsx or csv, but is there way to export data in another format. I had a stakeholder ask about gxp files...

[Ritaf1983 · Accepted solution]

Hi @kewaynes

Currently, Power BI only supports exporting to the following formats: Excel (XLSX), CSV, PDF, and PowerPoint.
If you'd like to suggest exporting in the GXP format, you can submit your idea here:

https://ideas.fabric.microsoft.com/ideas/search-ideas/?q=export%20gxp&currentSelected=

In terms of potential workarounds, here are some ideas you can try:

Power Automate (Microsoft Flow): You can create an automation flow to export data from Power BI and convert it to a different format, like GXP, using a custom script.
Power Query: You could export the data to an existing format (like CSV or Excel) and then use external tools to convert it into GXP format.
API or Custom Code: Use the Power BI REST API to extract data and then convert it to GXP using a custom script (e.g., in Python or .NET).
Third-Party Tools: There are third-party tools that may offer additional export options, potentially including the GXP format.
Please note that these suggestions are at the idea level and have not been tested personally.

If my answer was helpful please give me a Kudos and accept as a Solution.

[kewaynes]

Thanks Rita