Forum Discussion

Jame1212's avatar
Jame1212
New Member
10 years ago
Solved

Access Database in Power BI Online

Hello,   for a company I want to develop a dashboard based on a MS-Access database I built. On my PC I can import the data by using "Power BI for Desktop" - "Start" - "Load data" - "Other" - "MS-A...
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi Jame1212,

    We are not able to directly import data from Access database to Power BI Online Service.

    However, you can connect to Access database from Power BI Desktop by using “Get data>More>Database>Access database” option, create reports in it and save the Power BI Desktop(PBIX) file. You can then publish the PBIX file to Power BI Online service or connect to the PBIX file via “Get data>Files” option of Power BI Online Service, this way, you are able to develop a dashboard based on the MS-Access database.

    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi Jame1212,

We are not able to directly import data from Access database to Power BI Online Service.

However, you can connect to Access database from Power BI Desktop by using “Get data>More>Database>Access database” option, create reports in it and save the Power BI Desktop(PBIX) file. You can then publish the PBIX file to Power BI Online service or connect to the PBIX file via “Get data>Files” option of Power BI Online Service, this way, you are able to develop a dashboard based on the MS-Access database.

Thanks,
Lydia Zhang

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hey Anonymous - thanks for the suggestion.

     

    If you load data from the Access Database in Power BI desktop, then publish the PBIX file to Power BI service, will Service be able to refresh the dataset on a schedule?

  • mnargotra's avatar
    mnargotra
    New Member
    10 years ago

    I am trying to connect to Access database from Power BI but it keeps loading the data(screen keeps blinking) and then it stops responding. is it because data is huge?

    what could be the reason?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I added the filter in MS access and saved which would send only filtered data to Power BI, once done with report development then removed the MS access filters and loaded all while publishing, you can also use top 100 records.  There is no direct query option for MS access as source hence this should be used as import only.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Power BI service cannot refresh my dataset , which is Access DB in OneDrive, it gives the following error :

         

        Microsoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine 2010 Access Database Engine OLEDB provider may be required to read...

         

        When I refresh my local pbi file, it doesnt give me this error as I already have database engine installed. But Power BI service cannot read my database in OneDrive,  anyone knows why ?

         

  • PowerAccess's avatar
    PowerAccess
    Regular Visitor
    9 years ago

    Thanks for describing that useful workaround.


    For the following connection methods:

     

    A) import (embedded offline use),

     

    B) refreshable connection (import and scheduled or manual refresh), and/or

     

    C) live/direct query support

     

     

    Which of the above connection method(s) are supported in each of the following cases?

     

    1) Use from Power BI Desktop app

     

    2) Setup of connection from within Power BI Service (and/or Power BI Report Server?)

     

    4) .pbix imported into Power BI Service (and/or Report Server?)

     

    5) Installed Gateway connected to Access DB (for use from Desktop, Service, Report Server, and/or Mobile Apps?)

     

    6) Mobile Apps (connecting to Gateway directly, to Service, or to .pbix on OneDrive, if possible?)

     

     

    Also, what, if any, further enhancements for Microosft Access support are under development now or planned?

    Thanks again for your help,

    Dan