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

Christopher Ooi on 21 Dec 2023 15:10:12

RE: Power Query for Microsoft Access!

Yes. Power Query for Microsoft Access please. Thank you!

Power BI User's profile image Profile Picture

William Flynn on 06 Jul 2020 00:12:45

RE: Power Query for Microsoft Access!

Sounds like a great idea...

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:41:39

RE: Power Query for Microsoft Access!

TRUE

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:40:28

RE: Power Query for Microsoft Access!

Agree

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 22:56:24

RE: Power Query for Microsoft Access!

TRUE

Power BI User's profile image Profile Picture

Majd Yazigi on 05 Jul 2020 22:53:16

RE: Power Query for Microsoft Access!

Unless Microsoft go with the approach to enable access to connect to Power BI desktop and service, then I will keep being convinced that Microsoft is in the way of killing Access

Power BI User's profile image Profile Picture

LSky NLX on 05 Jul 2020 22:50:43

RE: Power Query for Microsoft Access!

Very much agreed, this would be very helpful!

Power BI User's profile image Profile Picture

Saur Dash on 05 Jul 2020 22:50:11

RE: Power Query for Microsoft Access!

Totally agree. I need to use Access for numerous processes and reports at work, currently I am cleaning/transforming my source data in Power Query before importing it into my databases. Integrating Power Query into Access would massively speed up this process.

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 22:48:10

RE: Power Query for Microsoft Access!

Agreed. I have a project that the Reporting tools in Access would be helpful. I need to take data I've transformed in Power Query and get it into a nicely formatted two column report with group headers and page breaks etc.

Power BI User's profile image Profile Picture

Chris Bischel on 05 Jul 2020 22:46:47

RE: Power Query for Microsoft Access!

Power Query (particularly content packs like the salesforce connector) would be awesome to have!