Forum Discussion
Extract data from PowerBI
Hello, Is it possible to extract data from PowerBI desktop or web app ? I import data from PostGre DB, mashing up, create new columns and measure then design a Dashboard. Some dashboard helop m...
Would this R-scripting tip work for you?
require(gdata)
write.table(trim(dataset), file=”your filepath & filename.txt”, sep = “\t”, row.names = FALSE)
plot(dataset);
http://www.thebiccountant.com/2015/12/28/how-to-export-data-from-power-bi-and-power-query/
https://www.youtube.com/watch?v=56FV6x8vYyQ
There are some limitations outlined on Imke's Biccountant blog.
Hope that helps
Thanks for the suggestion. The dashboards are shared with our clients so unfortunately the R-Script would not work in this example. Since this post l have raised a ticket and the PowerBI support team have confirmed what we are seeing is a bug, they are looking at it just now.
Robert