cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Jame1212 New Member
New Member

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-Access".

However on https://app.powerbi.com/groups/me/getdata// I am not sure which source to use. I suggested data, but I can only upload Excel-files, not an Access database.

 

What do I have to do? Databases and more? But which one?

 

Kind regards

 

Jannik Meerkamp

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Access Database in Power BI Online

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Moderator v-yuezhe-msft
Moderator

Re: Access Database in Power BI Online

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

mnargotra Frequent Visitor
Frequent Visitor

Re: Access Database in Power BI Online

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?

PowerAccess Visitor
Visitor

Re: Access Database in Power BI Online

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

st034045 Frequent Visitor
Frequent Visitor

Re: Access Database in Power BI Online

Hey @v-yuezhe-msft - 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?

Seenuvasans3 Frequent Visitor
Frequent Visitor

Re: Access Database in Power BI Online

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.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)