Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
User | Count |
---|---|
93 | |
87 | |
68 | |
62 | |
58 |
User | Count |
---|---|
149 | |
113 | |
95 | |
80 | |
72 |