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

Could not connect to datasource

Hi Guys,

 

I have a premium capacity workspace and added a viewer without Pro Licence. That user has also read permissions on the dataset.

So here is my problem:

When I asked the user if he can read the report he is able to open it, but  the message " could not connect to datasource " appears.

We are using a gateway to connect with the datascource.

 

Can anyone tell me what is wrong?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Re: Could not connect to datasource

Hi Guys, the problem has solved. It was caused by an a4 sku, so we can't share reports to free users.

 

 

View solution in original post

3 REPLIES 3
Highlighted
Microsoft
Microsoft

Re: Could not connect to datasource

Hi , @Dickkieee 

Which data sources do these reports get data from? Which connection mode do you use, import, DirectQuery or Connect Live? 

It is suggest you check if the data source in Manage Gateways and credential in Dataset Settings for the dataset are fine. Also please check the Privacy level setting for  data source in Manage Gateways section. 

 

Best Regards,
Community Support Team _ Eason

Highlighted
Frequent Visitor

Re: Could not connect to datasource

Hi,

 

We are connecting to a Postgres datasource with directquery. I checked the datasource and credentials, but they are all fine. Privacy level is set to non and the viewer can build.

 

Really strange. Are there any more suggestions? Could it be related to the ticket below?

 

https://community.powerbi.com/t5/Service/RLS-in-Paginated-Reports-User-cannot-view/m-p/1090298#M9601... 

 

Kind regards,

 

 

Highlighted
Frequent Visitor

Re: Could not connect to datasource

Hi Guys, the problem has solved. It was caused by an a4 sku, so we can't share reports to free users.

 

 

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!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.