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?