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

Trouble connecting to Power BI datasets (services) from Desktop

Hi all,

 

I have published a dataset to reporting services (Redshift connection using DirectQuery), when I myself go to connect to that same data set again via Power-BI data sets, that works fine.

 

However, noone else within that same workspace seems to be able to do so. How would I set this up so that my co-workers can work my published data set within Power BI desktop?

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support
Community Support

Re: Trouble connecting to Power BI datasets (services) from Desktop

Hi @jjlek 

As tested, if i publish a dataset using DirectQuery to Power BI Service,

without adding the data source under the gateway and adding the users as users of the gateway,

the users has no acess to the dataset, so they can't connect to the power bi service dataset via Power BI Desktop.

After setting it correctly, it works.

 

Best Regards
Maggie

 

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

View solution in original post

Community Support
Community Support

Re: Trouble connecting to Power BI datasets (services) from Desktop

Hi @jjlek 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

 

Best Regards

Maggie

View solution in original post

3 REPLIES 3
Community Support
Community Support

Re: Trouble connecting to Power BI datasets (services) from Desktop

Hi @jjlek 

First, what error do you meet?

Second, check steps for using the Power BI service live connection.

Please note:

  • Only users with Build permission for a dataset can connect to a published dataset using the Power BI service live connection. Learn more about setting the Build permission.

Lastly, do you add the data source (direct query connection) under the gateway, and add the users (who connect to the shared dataset) under the gateway?

 

Best Regards
Maggie

 

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

Community Support
Community Support

Re: Trouble connecting to Power BI datasets (services) from Desktop

Hi @jjlek 

As tested, if i publish a dataset using DirectQuery to Power BI Service,

without adding the data source under the gateway and adding the users as users of the gateway,

the users has no acess to the dataset, so they can't connect to the power bi service dataset via Power BI Desktop.

After setting it correctly, it works.

 

Best Regards
Maggie

 

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

View solution in original post

Community Support
Community Support

Re: Trouble connecting to Power BI datasets (services) from Desktop

Hi @jjlek 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

 

Best Regards

Maggie

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors