Power BI

New

Power Query for Microsoft Access!

Vote (99)

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 (17)

Comments (17)

ef41daee 6dd7-44f6-98eb-4f33ca62c7f9 on 05 Jul 2020 22:42:16

RE: Power Query for Microsoft Access!

At the very least, give MS Access the ability to link to a Power Query connection only query.

6aef0429 c982-457a-8a1c-760a6f78a6fb on 05 Jul 2020 22:39:49

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.

5b99fee0 40df-4122-bd06-62e82474ad59 on 05 Jul 2020 22:35:01

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.

75ba21fd ecc8-4a68-9d3d-c260cf249907 on 05 Jul 2020 22:32:12