Getting error while exporting to excel with table visual

[RajuG]

I am getting "File couldn’t be created. Executing the Query for the Export Data operation resulted in an error." this error while exporting data from table visual it in the direct query  mode and the data volume is 10M rows. However it has limitation of exporting 1.5M rows it should download with the 1.5M rows but it is failing.

[v-kpoloju-msft]

Hi @RajuG,

Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to @tharunkumarRTK, @nielsvdc, for those valuable insights on this thread. 

Has your issue been resolved? If the response provided by the community member @tharunkumarRTK, @nielsvdc, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

Thank you for using the Microsoft Community Forum.

[v-kpoloju-msft]

Hi @RajuG,

Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

Thank you.

[tharunkumarRTK · Accepted solution]

@RajuG 

The max number of rows that you can export is 150K not 1.5 Million. With direct query based storage mode there are few other limitations 

Kindly checkout the "Considerations and Limitations" section in this page

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-d...

If you want to export only top 150K rows probably you use visual level "Add Data Limit" functionality 

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[nielsvdc]

Hi @RajuG, you might try setting the limit of the visual to the top 1.5M records. That way you are not hitting the limit. But keep in mind you can also hit the 16MB export limit when you have large amount of columns.

Hope this helps. If so, please give a Kudos 👍 or mark as Accepted Solution ✔️.