Forum Discussion
Do we maintain query control on dataset shared with Client.
rwjg，
Yes. You can write SQL query in Power BI Desktop to import certain data, create report in Desktop and publish the report into app Workspace of Power BI Service, then add your clients as members of the app workspace and grant them edit permissions. In this case, they are able to access the dataset in Power BI Service and unable to access to your database directly, but please note that your clients should be in same domain as you in order to successfully add them as members of app workspace.If you are in different domains, you can directly send the PBIX file to your clients, they can add their own visuals in Power BI Desktop.
Regards,
Lydia
rwjg,
Firstly, based on the above quote, it seems that your client asks for that if there is a possibility to get/migrate data from your data source to Service-Now, and your client want to import data from Service-now to Power BI, then create Power BI reports.
Secondly, I am not sure about your requirement. If you want to share Power BI report to your clients without providing them access to the underlying data source/dataset, it is possible in Power BI. You can share Power BI report/dashboard to your client. However, if you want to migrate data from your data source into Service-now, this question is out of Power BI's scope.
Thirdly, to share Power BI dashboard/ report to clients, both you and your clients require Power BI pro license.
Regards,
Lydia
Good Afternoon.
Thank you for your response.
The customer is definitely looking for a dataset that they can access directly from their Power BI environment.
My primary question is; Can we control what the client has access to? I.e. Can I write a SQL Query which generates a certain dataset, and the customer can remote hook into the results of that Query only, instead of getting access to our database directly.
That query would remain under our control, in case we need to make changes.
Thank you in advance,
Sincerely,
Rudy
rwjg，
Yes. You can write SQL query in Power BI Desktop to import certain data, create report in Desktop and publish the report into app Workspace of Power BI Service, then add your clients as members of the app workspace and grant them edit permissions. In this case, they are able to access the dataset in Power BI Service and unable to access to your database directly, but please note that your clients should be in same domain as you in order to successfully add them as members of app workspace.If you are in different domains, you can directly send the PBIX file to your clients, they can add their own visuals in Power BI Desktop.
Regards,
Lydia