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

Connecting to existing datasets

Has anybody been able to connect to an existing dataset?

I have succeded in getting data to the Desktop application using an OleDb connector but then the service refuses to authenticate so I can't keep the report updated.

Any help is appreciated here.

2 REPLIES 2
Moderator v-qiuyu-msft
Moderator

Re: Connecting to existing datasets

Hi @mauropasi,

 

It seems you want to refresh OLEDB dataset published in the service, right?

 

As the OLEDB is a on-premise data source which requires gateway to build connection between the Power BI service and data source. You can install the personal gateway on the server which hosts the OLEDB data source, then configure the dataset to use this personal gateway. For more information, see: Power BI Gateway - Personal.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
eskyline Member
Member

Re: Connecting to existing datasets

Mauropasi,

 

Are you using the on premisis data gateway?  Since you say the service refuses to authenticate are you seeing the error when you are creating the connection in "Manage Gateways"?  I'd be sure I'm using the same credentials when defining the connection in Manage Gateways as I'd used when I connected to the data in the Power BI Desktop.  If all else failed I'd start by making sure whatever user I did chose to use in the connection had the highest priveledges possible on the database to start.  If I got things working then I'd like it back.  I'd also check the gateway logs.  There are two logs that it creates on the system where it is installed.  One is config type data but the other is actual query request type data so thats the one I'd look for.

 

 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors