Forum Discussion
Passing query parameters from Service App
Hi,
I am working on developing a Customer Profitability Analysis App. We have a huge SQL table containing information about our many customers, and I would like to pass Parameters to my SQL query connection in order to only retreive information for specific accounts
The accounts would have to be somehow selected by the user, within PowerBI Service.
Is this possible? any help would be great
Thanks
HI, adriandim
Based on my research, I'm afraid it couldn't achieve in Power BI for now.
As a workaround, You may try to use RLS in power bi, import the customers information and then set RLS.
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
http://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi
http://radacad.com/row-level-security-configuration-in-power-bi-desktop
Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.
Best Regards,
Lin
4 Replies
HI, adriandim
Based on my research, I'm afraid it couldn't achieve in Power BI for now.
As a workaround, You may try to use RLS in power bi, import the customers information and then set RLS.
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
http://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi
http://radacad.com/row-level-security-configuration-in-power-bi-desktop
Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.
Best Regards,
LinThis is what I thought! Thanks for your reply v-lili6-msft
This is what I thought! Thanks for your reply v-lili6-msft
hi, adriandim
You are welcome :smileyhappy:
Could you please tell me if you have other problem? If not, could you please mark the helpful replies as Answered?
Best Regards,
Lin
