How to export Error Query into Excel

[SriKandimalla]

Hello PBI Community,

I have few queries and when I tried to "Close&Apply" there were few error rows and I clicked "See errors". So, we can see the errors in a new query generated by Power BI and called as Errors in "TABLENAME".

Now, my question is, Is there a way to export that into excel or csv?

Thanks in Advance. As always I appreciate your help

[v-diye-msft · Accepted solution]

Hi @SriKandimalla 

Here is one solution:

https://community.powerbi.com/t5/Desktop/Export-to-csv-from-Power-Query/td-p/193423

The other method would be to insert an R script step in your query to do the output.

[Anonymous · Accepted solution]

@SriKandimalla 

You can use this to export as CSV with R scrhipt 

# 'dataset' holds the input data for this script
write.csv(dataset, "C:\\Users\\user\\Desktop\\test\\test.CSV")

write.csv(dataset, "Destination\\test.CSV")

May the BI force be with you! If this post helps, then please consider Accept it as the solution to help the other members find it more quickly! Thanks!

[v-diye-msft · Accepted solution]

Hi @SriKandimalla 

Here is one solution:

https://community.powerbi.com/t5/Desktop/Export-to-csv-from-Power-Query/td-p/193423

The other method would be to insert an R script step in your query to do the output.