Power BI User on 16 Jul 2015 05:21:41
Sometimes I need to transform data utilizing power query and then upload or link from excel into MS access.
It would be very helpful if we could have this tool in Microsoft Access as well
- Comments (18)
RE: Power Query for Microsoft Access!
Agreed!
RE: Power Query for Microsoft Access!
At the very least, give MS Access the ability to link to a Power Query connection only query.
RE: Power Query for Microsoft Access!
All for this integration. Power Query is extremely useful for JSON interrogation. Be good to see a comment here from Microsoft BI as to whether Access integration is in the roadmap and if so when.
RE: Power Query for Microsoft Access!
My vote for having power query in MS Access too... I am presently struggling with using Access to query against custom JSON WebAPI's. Only approach I have been able to get limited success in, is to create a power query in Excel, then create a linked Excel table in Access - which is fine for static WebAPI calls, but not for parameter driven WebAPI calls.
RE: Power Query for Microsoft Access!
Definetely! It would be extremely helpfull
RE: Power Query for Microsoft Access!
Agree, that would be very helpful!
RE: Power Query for Microsoft Access!
This is necessary for advanced reporting needs.
RE: Power Query for Microsoft Access!
I agree with you