Forum Discussion
How do I pass parameters to a dashboard
No, row-level security is what you're looking for. The reason I asked about the API is because this section of the forum tends to focus on the Power BI API / Embedded version.
You'll most likely want to target this question in the "Desktop" forum. I'll give a little more clarity:
Does your dataset currently capture the sales team member's email address anywhere? For instance, do you have a 'User' table that has the UserID, Email, Name, etc? If you do, then your data is perfectly shaped to use RLS wih the USERNAME() DAX function. This would filter would capture the user's email address (Office 365 account) when they view the report and filter the dataset accordingly.
I strongly suggest checking this out, it should give you enough guidance: https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/.
No, row-level security is what you're looking for. The reason I asked about the API is because this section of the forum tends to focus on the Power BI API / Embedded version.
You'll most likely want to target this question in the "Desktop" forum. I'll give a little more clarity:
Does your dataset currently capture the sales team member's email address anywhere? For instance, do you have a 'User' table that has the UserID, Email, Name, etc? If you do, then your data is perfectly shaped to use RLS wih the USERNAME() DAX function. This would filter would capture the user's email address (Office 365 account) when they view the report and filter the dataset accordingly.
I strongly suggest checking this out, it should give you enough guidance: https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/.
Hi,
This might be a similar problem I ran into. I have a big stored procedure where I am pullig many data point on each company we do business with. I have a company ID which is main ID for the report. What I am trying to do is the following:
We have our own CRM where we have info on each company and there would be an option to click on a link that would open the Power BI report automatically displaying only the data set and visuals for the respective company. Is this possible in Power BI?
We have done this in the past in SSRsS by creating a parameter which was the company id and passing it through our CRM to accomplish this task. However, loading and eveything else takes very long and we are migrating all our reporting efforts to power BI. I was wondering if you have any guidance on that and whether I can do this in Power BI or do I need to stick to SSRS?
Thank you and have a great day.
Lukas