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
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
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)