Forum Discussion
Solved
Data source: access db, does not work sometimes
Hello, I’m reaching out for your help in understanding an issue I’m experiencing with one of our dataflows. I have an Access database stored in a shared folder, which I’ve been accessing without...
- Verify folder permissions with IT to ensure your Microsoft account still has access.
- Use UNC path (e.g., \\Server\Folder\file.accdb) instead of mapped drives.
- Ensure stable network/VPN connection when refreshing the dataflow.
- Install and configure On-premises Data Gateway if accessing from Power BI Service.
- Clear and re-enter credentials in Power BI under Data Source Settings.
- Verify folder permissions with IT to ensure your Microsoft account still has access.
- Use UNC path (e.g., \\Server\Folder\file.accdb) instead of mapped drives.
- Ensure stable network/VPN connection when refreshing the dataflow.
- Install and configure On-premises Data Gateway if accessing from Power BI Service.
- Clear and re-enter credentials in Power BI under Data Source Settings.
Thank you for your help !
In the end the issue was related to the fact that machine with gateway lost access to folder with database
