I've ran into an issue with using the Power BI gateway to refresh an Access database and hoping for some help.
There is an Access database stored on a family friends small business computer which contains client and booking information (e.g. C:\database\database.accdb)
I have obtained a copy of this database and created a report off the local copy on my computer
I have downloaded Power BI gateway (logged in under my account and under a personal install) on the business computer so it can refresh the Access DB for me
What I'm hoping to understand is how I can continue to develop on the copy of the database I have and then "switch" the data source over to the one on the business computer which needs to be continuously updated via Power BI gateway.
I've tried ensuring that the file path is identical on both computers, and then validating credentials in Power BI online which succeed, but as soon as I click refresh it causes a failure which isn't very descriptive:
At this stage the only way I can see for this to work is if I install Power BI on the business computer, point the report to the database on the computer and then upload - but i'm hoping there is another way...