cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
garethp
Frequent Visitor

Help with Power BI gateway

Hi guys,

 

I've ran into an issue with using the Power BI gateway to refresh an Access database and hoping for some help.

 

The scenario:

  • 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:

 

 

Cluster URIWABI-AUSTRALIA-EAST-A-PRIMARY-redirect.analysis.windows.net
Activity IDc41ff94c-a53e-4605-b5c5-69c15203b86a
Request IDcca03cdb-a96e-4bc7-e143-ee472c216198
Time2020-02-20 09:49:31Z

 

 

 

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...

 

Any help would be much appreciated!

 

1 ACCEPTED SOLUTION
garethp
Frequent Visitor

In case it helps anyone I managed to solve this by:

 

  1. Uninstalling the personal gateway and installing the on-premises one
  2. Updating the report data source location to the business computers path to the file
  3. Installing Access 2010 database engine on the business computer (stopped update errors from occuring) 

View solution in original post

1 REPLY 1
garethp
Frequent Visitor

In case it helps anyone I managed to solve this by:

 

  1. Uninstalling the personal gateway and installing the on-premises one
  2. Updating the report data source location to the business computers path to the file
  3. Installing Access 2010 database engine on the business computer (stopped update errors from occuring) 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors