Skip to main content

Power BI

Needs Votes

Power Query for Microsoft Access!

Vote (102) Share
Power BI User's profile image

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)
Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 22:43:08

RE: Power Query for Microsoft Access!

Agreed!

Power BI User's profile image Profile Picture

Kirk Phillips 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.

Power BI User's profile image Profile Picture

Power BI User 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.

Power BI User's profile image Profile Picture

Power BI User 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.

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 22:32:12

RE: Power Query for Microsoft Access!

Definetely! It would be extremely helpfull

Power BI User's profile image Profile Picture

Soenke Stange on 05 Jul 2020 22:31:29

RE: Power Query for Microsoft Access!

Agree, that would be very helpful!

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 22:17:39

RE: Power Query for Microsoft Access!

This is necessary for advanced reporting needs.

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 22:17:21

RE: Power Query for Microsoft Access!

I agree with you