Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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.
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")
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")
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.