Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have several data sources located on a file server in a special folder. My IT department configured an enterprise gateway refering to this special folder. This setup works fine for xlsx files. Unfortunately it doesn't work properly for my MS Access database. When creating the Report in Power BI desktop I connected the database by "folder" - "binary" and chose the correct table. In PBI Desktop everything works fine. I can refresh without problems. After publishing the report to PowerBI services I configured the gateway. The gateway connection is working. When refreshing the dataset I get the following error.
Does anybody have an idea how to solve this issue.
Thank you very much for your support.
BR Sebastian
Hi Sebastian,
I am facing the same issue.
Did you get a chance to find the root of this issue?
Could you please share the solution?
Thanks,
Hi @Basti ,
If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!
Best Regards,
Yingjie Li
Hi @Basti ,
Have your enterprise gateway and Access database been installed on the same machine? On-premiss gateway supported Access database but please note that: Supported with the ACE OLEDB provider, installed on the same machine as the gateway.
If you are using a custom ODBC connector to connector in gateway , please consider the following limitation in this document:
Please also refer to this similar thread: https://community.powerbi.com/t5/Service/ODBC-in-On-Premise-Gateway-Data-Source-Error/td-p/841330
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.