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

Re: Report couldn't access data source in Direct Query mode

I've created the same test on my own pc with a local sql server and published it. And this works fine.

Your suggestions about the credentials are probably right. Now its up to me to figure this one out.

At first I published from Desktop using the import sql feature, later I used (with a new file) the direct query option. Both using the same gateway. Can this somehow be the root of the problem?

 

Thanks for the help. I´ll keep this thread open for a little longer until I got it working on premise

 

zoloturu
Advisor

Re: Report couldn't access data source in Direct Query mode

@Sjors,

 

Did you map user from PBI service to Windows account user here?

 

mapping.pngmapping

Sjors Regular Visitor
Regular Visitor

Re: Report couldn't access data source in Direct Query mode

I don't have a button for this. I can only add or remove users

zoloturu
Advisor

Re: Report couldn't access data source in Direct Query mode

@Sjors,

 

If you configured Gateway but yourself then you should have user under USERS tab (see screenshot). Provide your screenshot.

Sjors Regular Visitor
Regular Visitor

Re: Report couldn't access data source in Direct Query mode

This was not the problem. I deleted the data source under the gateway and added it again. Now it works 

 

Sjors Regular Visitor
Regular Visitor

Re: Report couldn't access data source in Direct Query mode

No it had to do with the credentials in the gateway. Problem solved already. Thanks for the reply

gayathiridevi Frequent Visitor
Frequent Visitor

Re: Report couldn't access data source in Direct Query mode

Hi,

Im facing the same issue.

Could you pls provide me solution in detail.

Power bi desktop - basic auth or windows?

power bi service - ?

gateway connection for datasource is successful.

kindly advice!

 

Thanks

Anonymous
Not applicable

Re: Report couldn't access data source in Direct Query mode

Hi All,

Recently I installed On-premises data gateway (Standard Mode) on one of the Server Machine and configured it. 

 

When I try to open a report has a direct query on Power BI Web, I was getting error message 

"This repoer couldn't access the data source because it doesn't have permission. Choose another data gateway, or contact the gateway administrator"

 

To Solve this, I followed following steps:

  1. Connect to Power BI Service
  2. Settings--> Manage gateways and you will see your configured gateway
  3. Find the Data Source configured under this gateway and having an issue
  4. Double click on Data Source and you will see Data Source Settings
  5. At the end, there is an option "Advance settings". Expand this and uncheck option--> "Use SSO via kerberos for direct queries". Default It is checked. It says "This will only be applied for DirectQuery. Imports will use the Username and password specified in the source details Learn more: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem#credentials"
  6. Click on Apply and It started working for me. 
Highlighted

Re: Report couldn't access data source in Direct Query mode

Hi All,

Recently I installed On-premises data gateway (Standard Mode) on one of the Server Machine and configured it. 

 

When I try to open a report has a direct query on Power BI Web, I was getting error message 

"This repoer couldn't access the data source because it doesn't have permission. Choose another data gateway, or contact the gateway administrator"

 

To Solve this, I followed following steps:

  1. Connect to Power BI Service
  2. Settings--> Manage gateways and you will see your configured gateway
  3. Find the Data Source configured under this gateway and having an issue
  4. Double click on Data Source and you will see Data Source Settings
  5. At the end, there is an option "Advance settings". Expand this and uncheck option--> "Use SSO via kerberos for direct queries". Default It is checked. It says "This will only be applied for DirectQuery. Imports will use the Username and password specified in the source details Learn more: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem#credentials"
  6. Click on Apply and It started working for me.

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

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