Power BI

Needs Votes

Power Query for Microsoft Access!

Vote (102)

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)

Comments (18)

Christopher Ooi on 21 Dec 2023 15:10:12

RE: Power Query for Microsoft Access!

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

William Flynn on 06 Jul 2020 00:12:45

RE: Power Query for Microsoft Access!

Sounds like a great idea...

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

RE: Power Query for Microsoft Access!

TRUE

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

RE: Power Query for Microsoft Access!

Agree

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

RE: Power Query for Microsoft Access!

TRUE

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

LSky NLX on 05 Jul 2020 22:50:43

RE: Power Query for Microsoft Access!

Very much agreed, this would be very helpful!

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

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!