Include the ability to connect to new data sources such as those listed in POWER BI
New external data sources are growing rapidly and it would be useful to keep up-to-date and have ACCESS include these new types.
In the past 6 months we introduced 2 new modern data connectors to Access – Microsoft Dynamics and SalesForce (https://techcommunity.microsoft.com/t5/Access-Blog/Introducing-New-Connectors-in-Access-Microsoft-Dynamics-and/ba-p/100015)
We recognize that one of Access’ core strengths is the ability to connect to external data sources, and making investments to further expand the already available rich portfolio of external data sources.
If there are specific data sources that are interesting to you, please create a separate suggestion for them.
To effectively use Power BI in Access applications, we need the ability to drive its results programmatically instead of the user typing what they want. We also need a way to specify criteria to limit records.
James Muka commented
"Being able to use PowerBI from within Access would be so powerful."...I second the motion.
Thanks for asking. Here is my suggestion. Perhaps if you are able to pursue this idea, you could post a survey for other developers to contribute their weighting.
Outlook – better integration including Office 365 (really would like in Outlook a unique ID we could link to have related table information and have a project ID field which Outlook tasks could be linked as well as other Access table info)
Quickbooks (regular and Online)
Microsoft Dynamics CRM
SQL Analysis Services
I would like so see PowerBI integrated so that it can basically be a replacement for the current (and very old) MSChart. Wizard interface data binding etc
Being able to use PowerBI from within Access would be so powerful!