cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

I've set up that Gateway. I configured the access to the DB. Now how do I "Get Data" from that DB?

I hope you guys can help me. Those Power Bi tutorials sure don't. (It's not a Gateway setup question but how to access data sources from the gateway in Power Bi Desktop.)

 

The SQL server database for a vital business application of ours is running in the vendor's data centre.

I have procured and set up a VM with a VPN connection to that data centre and server. I have successfully tested access with SMSS 2005.

Subsequently, I have installed the Power Bi Data Gateway on that server.

Finally, I have logged into Power Bi Online and configured access to the database.

 

Now, how do I actually call onto that database via Power Bi Desktop? When clicking on "Get Data", there is no link to my sources in the Data Gateway.

How do I call on my database and respective tables at this point?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: I've set up that Gateway. I configured the access to the DB. Now how do I "Get Data" f

@UserBUG

 

The Data Gateway is only for Power BI Service (cloud side) contacting the on premise data source, which means Power BI Desktop will not use any gateway when connecting to your Access database. You just need to "get data" from Access directly in Power BI Desktop. 

 

Regards,

View solution in original post

1 REPLY 1
Highlighted
Microsoft
Microsoft

Re: I've set up that Gateway. I configured the access to the DB. Now how do I "Get Data" f

@UserBUG

 

The Data Gateway is only for Power BI Service (cloud side) contacting the on premise data source, which means Power BI Desktop will not use any gateway when connecting to your Access database. You just need to "get data" from Access directly in Power BI Desktop. 

 

Regards,

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors