Forum Discussion
Continued ContributorDataset access without DB access?
Hi itsmebvk
You can directly share your dataset with end users without giving them access to the data source .They can access the data from your datasource with Pro licenses or the dataset in Premium capacity with free licenses .
More info about sharing dataset can refer to the link
https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-share
I searched in MS but found no introduction about the usage metrics for Rest API . But you can monitor usage metrics for reports and dashboards in the new workspace experience.
For specific introduction, you can refer to the link
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-modern-usage-metrics
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Continued Contributor
Thanks for your valuable inputs.
We already have usage metrics dashboard which captures user activity from usage log.
Can you please help me with following questions.
Question1: Assume that I have Dataset with 3 tables which are direct query tables. Without giving users DB access is there any way to grant them to access Dataset ( except import route)?
Question2: Assume that I have used service account for Dataset configuration, but how Can I track user executed queries from Rest API usgae metrics?
I am really sorry if I ask same question. Thanks.
Community ChampionI can answer Question 1 : Grant them users access to the wrokspace, Users will need at least Power bi Pro license.
Question : not familiar with it. Sorry
- itsmebvk
aj1973 Thanks for your reply.
Does it means without DB access to users by giving Workspace access, can they create visualizations using datasets ( Direct Query) which are in that workspace?
- aj1973
Yes, DQ mode doesn't give permission to users to access the DB. Visualizations sends queries to the DB via DQ mode.