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)
RE: Power Query for Microsoft Access!
Yes. Power Query for Microsoft Access please. Thank you!
RE: Power Query for Microsoft Access!
Sounds like a great idea...
RE: Power Query for Microsoft Access!
TRUE
RE: Power Query for Microsoft Access!
Agree
RE: Power Query for Microsoft Access!
TRUE
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
RE: Power Query for Microsoft Access!
Very much agreed, this would be very helpful!
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.
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.
RE: Power Query for Microsoft Access!
Power Query (particularly content packs like the salesforce connector) would be awesome to have!