Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Report couldn't access data source in Direct Query mode

  I've created a simple report with PBI desktop. In desktop all works fine. When I open the report in the service i get the following error: Report couldn't access the data source because it doesn...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous I would assume that the credentials can access the SQL Server, otherwise you wouldn't be able to use the datasource. My thought is that while it can reach the SQL Server, it can't access all the tables/views that it needs to in order to produce the report results... what level of permission does it have on the SQL Server? Is it a different account, or your credentials?

    Alternatively, did you use a basic auth connection in the Desktop?

zoloturu's avatar
zoloturu
Memorable Member
8 years ago

Anonymous,

 

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

 

mapping

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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