Forum Discussion
Solved
Password protected Access Database - Gateway error
Hi all, I am fairly new to Power BI. I have an access database which is password protected. From my Power BI Desktop, I am able to successfully connect to it through OLE DB driver (Thanks to refe...
Thanks for your reply. The issue was because the database had an unconventional file extension. OLE DB connection was successful to the database in Desktop but not in PowerBI Service. To resolve this issue, I copied the database and stored as .mdb to establish an ODBC connection. Now, I am able to schedule data refresh in PowerBI Service using ODBC.
Hi rsangeetha
After doing this, can you refresh normally now ? If it has been solved, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards
Community Support Team _ Ailsa Tao