Forum Discussion
Integrating Power BI Report into Customer Dashboard
Your question is not dumb at all! It's a great question and it's always better to get an expert opinion before proceeding with a project.
To answer your question, you can achieve this by using Power BI's Row-Level Security (RLS) feature. RLS allows you to restrict data access based on user roles or permissions.
In your case, you could create a table in your database that maps each customer's login information to their unique identifier in your consumption data. Then, you can set up RLS in Power BI so that when a customer logs in to the portal, their unique identifier is passed through to the dashboard, which in turn filters the consumption data to only show data for that customer.
To implement this, you would need to set up a connection between your Power BI dashboard and your AWS database, and then set up the RLS rules in Power BI. You can find detailed instructions on how to set up RLS in Power BI on Microsoft's website.
Once you have set up RLS, you can publish the dashboard to the Power BI service and embed it into your customer portal so that customers can view their data in an interactive and dynamic way.
Responsive ResidentYour question is not dumb at all! It's a great question and it's always better to get an expert opinion before proceeding with a project.
To answer your question, you can achieve this by using Power BI's Row-Level Security (RLS) feature. RLS allows you to restrict data access based on user roles or permissions.
In your case, you could create a table in your database that maps each customer's login information to their unique identifier in your consumption data. Then, you can set up RLS in Power BI so that when a customer logs in to the portal, their unique identifier is passed through to the dashboard, which in turn filters the consumption data to only show data for that customer.
To implement this, you would need to set up a connection between your Power BI dashboard and your AWS database, and then set up the RLS rules in Power BI. You can find detailed instructions on how to set up RLS in Power BI on Microsoft's website.
Once you have set up RLS, you can publish the dashboard to the Power BI service and embed it into your customer portal so that customers can view their data in an interactive and dynamic way.
Thank you so much! This was so useful👌