Solved: Re: Report couldn't access data source in Direct Q... - Page 2

Anonymous · ‎01-03-2018

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't have persmissions.

The gateway is online and when I go to the data sets it refreshes every 15 minutes.

Where do i set the persmissions?

I connect to a sql server 2016 , with basic authentiction.

Seth_C_Bauer · ‎01-04-2018

@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?

Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

Anonymous · ‎01-09-2018

No this is the first one. Can you give me a hint on how to do this? Or Check it?

DirectQuery access via service is handled different than connecting via powerbi desktop?

Report couldn't access data source in Direct Query mode

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024