Forum Discussion

itsmebvk's avatar
itsmebvk
Icon for Continued Contributor rankContinued Contributor
5 years ago
Solved

Dataset access without DB access?

Hi Experts,   I need your experty and inputs in one of access related issue.   I created a composite model which has Three Fact , Three Dim Tables, Three Agg Fact Tables.  When it is impor...
data protection
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
5 years ago

Hi itsmebvk 

Implementing RLS to your dataset does not grant access to DB to users anyway of connection, that's why import mode works fine for you. However using DQ mode has some limitations. Please check out this image and see if your dataset hits one of theses limitations

I am guessing the once in yellow could be the cause

 

 

 

itsmebvk's avatar
itsmebvk
Icon for Continued Contributor rankContinued Contributor
5 years ago


aj1973 ibarrau 

 

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.