Incorporate Power BI as an Add-in to New version of Access 2017
Since Pivots & Charts have been removed from Ver 2010 onwards, its been a big problem for us consultants to provide charting and pivoting features to our customers. These are features simply adored by our customers due to their ease of use. But after looking at Power BI I feel since its from the same Microsoft family the Access Team should consider incorporating it in their Next Product Planning process.
Manish Batola
shared this idea
Thanks for posting and voting.
Integrating Power BI with Access is one of the things we believe will add value to Access developers and users. We are looking into ways to support that.
Keep voting if this is important to you – it will increase the likelihood of it getting in the product.
28 comments
-
Nick
commented
Please add pivot charts and pivot tables back into Access. Power BI will be fine but please add something.
-
Patrick
commented
This would definitely help me / my company. Looking for a way to use local parameters to control data access in Power Bi reports so the use of ODBC table (sql server) and then an embedded Power BI report would solve the issue. It would provide a user the ability use something other than a slicer and also allow for controlled access based on a user's login id.
-
Anonymous
commented
I really need this feature. Access is awesome to collect the data but the reporting abilities are limited compared to other products.
-
Anonymous
commented
Any updates?
-
re:
"Hope this also will include the possibility to link Excel tables into Access and make them editable"
That's not going to happen. Editing linked Excel 'tables' was removed quite some time ago due to a rather strange law suit against Microsoft by a company in the UK I believe. So, really not chance of that happening.
Note however that you can still 'edit' ( and more) Excel files via VBA code. -
PeterF
commented
Hope this also will include the possibility to link Excel tables into Access and make them editable
-
James Muka
commented
Any thoughts on this Access Team?
-
James Muka
commented
Access Team...any update on Power BI directly in Access? Please let us know so we can plan accordingly.
-
Access Team ... any update on this ?
-
Anonymous
commented
Why? Power BI doesn't support pivot tables.. only the excel way.. no way!
-
John
commented
While this would be a nice to have, I really don't see a lot of value in including it in Access at this time. It is intended to be a business intelligence tool which is new and constantly changing. POWER BI is awesome but Access is awesome at creating, manipulating and reporting data on a day-to-day production basis. There are many features in Access that Microsoft resources could be working on that I would rather see those being developed knowing I can link to Access files in POWER BI for analysis anyway. These are 2 different groups of users anyway.
-
pflipper
commented
This would be a huge benefit to Access development. Many users have no interest in how the navigation environment gets created, but are very particular on what the output should be and how it should look. Allow Access to integrate with Power BI would allow developers to create a great app with some canned reports, but give users the flexibility to tweak the reports as they wish. A "win-win" in my opinion.
-
Tim
commented
Please add all PowerBI desktop features into the next version of Microsoft Access including the support for "R" script. Biologists love to use "R" scripts and too many small biological databases can not be merged and stored in Access databases or text files. Thank you.
I am disappointed that Microsoft has not invested much in Microsoft Access database technology lately.
-
Tao Gui
commented
SQL Server Express is just a database engine. It does not have data entry forms and reports built into it. This is the reason we still use Access database as our rapid development tool. Please add mobile devices support to Access. The new version of Filemaker can work with iPAD, iPhone and Android devices. Filemaker is owned by Apple. Please add these features to Access. Thank you.
-
Tao Gui
commented
Please include Power BI feature and DAX in the new version of Desktop/Web Access database. We have many ecological databases. These databases are often needed in the backcountry or remote site by researchers where there are no internet connection. If Microsoft does not improve Access database technology, we will use Filemaker which is owned by Apple. The new version of Filemaker can work with iPAD, iPhone and Android devices. Excel is not a database. I would prefer BI feature built in Access database than Excel.
-
Anonymous
commented
Great use cases for BI in access. Please do this.
-
pflipper
commented
I vote "yes" for this. It seems like integrating the two make a lot of sense for both products.
-
Adrian Bell (MVP)
commented
I would suggest, if Pivot Charts is what you really want to see, that you post such a proposal, or vote for an existing one if that suits you better.
I'm not sure that such a comment, in here, helps to focus the team on what should be worked on.
-
Mark Woodhead
commented
Power BI would be great, but all my Access 2007 version apps use Pivot Charts, so I am concerned about their future and how I will upgrade them to 2017. Bringing back Pivot Charts may be the simpler option.
-
B. Clothier
commented
Just to provide a link to Doug Y's suggestion:
