Skip to main content

    Power BI

    New

    Power Query for Microsoft Access!

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

    8941e93e 011c-4aed-9ed6-0c791b799c00 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

    c78fa186 cbc4-415c-ab27-480320ba672a on 05 Jul 2020 23:41:39

    RE: Power Query for Microsoft Access!

    TRUE

    Power BI User's profile image Profile Picture

    91e67ec2 3203-41d1-a5d4-58915628f469 on 05 Jul 2020 23:40:28

    RE: Power Query for Microsoft Access!

    Agree

    Power BI User's profile image Profile Picture

    b557eb80 0dd1-459a-9e27-5f49cf90d850 on 05 Jul 2020 22:56:24

    RE: Power Query for Microsoft Access!

    TRUE

    Power BI User's profile image Profile Picture

    aa16eba2 bc25-42ae-b597-392b99bf806b 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

    ec63ca62 9fd8-4221-99d4-6b5d00a98d48 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

    c0c421a8 5b0b-4b10-b5bb-9cc89454313f 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

    195fab74 4225-499a-90b6-ec26b14141b2 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

    ac977e12 de5c-4f4e-9228-f4405e1118f0 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!

    Power BI User's profile image Profile Picture

    c42b9c2c 2c46-4070-b942-8d71ed0bb1fa on 05 Jul 2020 22:43:08

    RE: Power Query for Microsoft Access!

    Agreed!