Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
akwang
Helper II
Helper II

Get Data Access ODBC Links

I am trying to get data from an access file with a linked table.

 

1.jpg

But I don’t see those tables when I load into power BI. Can you help me?

1 ACCEPTED SOLUTION
CahabaData
Memorable Member
Memorable Member

It is because those are not Access tables.  You are displaying the Access navigation pane -  it shows the tables - but the icon of the Globe with arrow means that Access is in turn linking to another ODBC database.  These are not tables that reside within Access.

 

You must link your PBI direct to that same back end database.

 

 

www.CahabaData.com

View solution in original post

1 REPLY 1
CahabaData
Memorable Member
Memorable Member

It is because those are not Access tables.  You are displaying the Access navigation pane -  it shows the tables - but the icon of the Globe with arrow means that Access is in turn linking to another ODBC database.  These are not tables that reside within Access.

 

You must link your PBI direct to that same back end database.

 

 

www.CahabaData.com

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.