Unable to Connect Access db to PBI Desktop

[teemcho]

Hello,

I created an Access database that pulls from several SharePoint lists that I have read access to. On the Access side all the queries are functioning as they should. However, when I attempt to import it via Power BI Desktop I receive the following error message:

"DataFormat.Error: The Microsoft Access database engine could not find the object 'tblVendor.' Make sure the object exists and that you spell its name and the path name correctly. If 'tblVendor' is not a local object, check your network connection or contact the server administrator." 

Does this have to do with a lack of permissions somewhere? Any guidance or help to resolve this would be greatly, greatly appreciated! 

[Anonymous]

Hi @teemcho ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

Best Regards,
Eyelyn Qin

[teemcho]

Hi @Anonymous ,
I'm still unable to successfully connect the Access db to PBI Desktop. However, due to an existing deadline we went ahead and utilized Excel flat files as the data sources and will manually maintain those for the time being. 

Thank you!

[teemcho]

@Anonymous @amitchandak ,

I did some testing and found out the root of the issue. It looks like Power BI is unable to connect to linked tables on the Access side. When I convert the tables from linked to local PBI is fine. 

Is there any way around this as we want to ensure there's always fresh data represented on PBI. If I connect to local tables would I just need to refresh the Access database manually? 

Thank you!

[Anonymous]

Hi @teemcho ,

I still could not reproduce your problem until now...

The error generally occured when you don't have access of that file over network or in connection string, it unable to reach the destination file. It may be related to the environment, account number and many other factors as well. Please check these aspects.

Hope these help.

https://community.powerbi.com/t5/EdX-Specific-Training-Discussion/Cannot-connect-to-sample-Access-db...

https://community.powerbi.com/t5/EdX-Specific-Training-Discussion/Get-Data-Unable-to-connect-to-Acce...

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[teemcho]

Hi @amitchandak ,

Thank you for responding. When you say permissions are you referring to the SharePoint lists feeding into the Access db or the Access db itself? I currently have site manager level permissions on the SharePoint site where the lists are housed. And the Access db I created myself as a test. 

Is there anywhere else I can check? 

[amitchandak]

@teemcho , can you check you have access on the file. means is a third party application can access it. Please check permission given

As per the document it is access related issue

https://social.msdn.microsoft.com/Forums/office/en-US/4b4dceed-a45b-4d6d-b53b-4e584244f65b/the-micro...