
Excel Expert
Operations Management
Excel Customer Service

December 3, 2016

Hi
I am aware that MS released Get data from PDF around August 2020 for Office 365 users in the US and other parts of the world.
So far it is still not available in this part of the world (Ireland).
I have registered to receive updates as they are released.
Is there a way to find this out - I tried post a message to Office support but got no reply.
If anyone has a suggestion, I would appreciate it.
Pat

Excel Expert
Operations Management
Excel Customer Service

December 3, 2016



November 8, 2013

in Power BI, you can easily export to a csv or xlsx, you cannot do that in excel Power Query.
If you install R language support for Power BI , you can write a query to export the result of the query:
Transform->Run R Script
write.csv(dataset,"e:\\test.csv")
For export in xlsx, install package openxlsx in R GUI ,
require(openxlsx) write.xlsx(dataset,"e:\\test.xlsx")
Or, to export in xlsx and a defined table:
require(openxlsx) write.xlsx(dataset,"e:\\test.xlsx", asTable = TRUE)
It's still your best option, unless you want to wait for Microsoft, this can take years...
1 Guest(s)
