I suggest you ...

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.

444 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Manish Batola shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    Under Review  ·  AdminAccess Team (Admin, Microsoft) responded  · 

    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.

    29 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Nick commented  ·   ·  Flag as inappropriate

        Please add pivot charts and pivot tables back into Access. Power BI will be fine but please add something.

      • Patrick commented  ·   ·  Flag as inappropriate

        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  ·   ·  Flag as inappropriate

        I really need this feature. Access is awesome to collect the data but the reporting abilities are limited compared to other products.

      • Joe Anderson (Access MVP, aka DatabaseMX) commented  ·   ·  Flag as inappropriate

        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  ·   ·  Flag as inappropriate

        Hope this also will include the possibility to link Excel tables into Access and make them editable

      • James Muka commented  ·   ·  Flag as inappropriate

        Access Team...any update on Power BI directly in Access? Please let us know so we can plan accordingly.

      • John commented  ·   ·  Flag as inappropriate

        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  ·   ·  Flag as inappropriate

        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  ·   ·  Flag as inappropriate

        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  ·   ·  Flag as inappropriate

        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  ·   ·  Flag as inappropriate

        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.

      • pflipper commented  ·   ·  Flag as inappropriate

        I vote "yes" for this. It seems like integrating the two make a lot of sense for both products.

      • Adrian Bell (MVP) commented  ·   ·  Flag as inappropriate

        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  ·   ·  Flag as inappropriate

        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.

      ← Previous 1

      Feedback and Knowledge Base