Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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.
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
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
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.
Hi @jjlek
First, what error do you meet?
Second, check steps for using the Power BI service live connection.
Please note:
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |