web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Power BI report data b...
Microsoft Dynamics CRM (Archived)

Power BI report data based on the logged in user in D365 Portal

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

We are embedding Power BI reports in D365 Portals. We want to show data in report which is related to the user.

For Example:  After Successfully login into the Portal, User should able to see the report of Support tickets related to his organization.

If user has no Power Bi account how he can see the report and we don't want to use anonymous report?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Jarrod Williams Profile Picture
    Jarrod Williams 1,747 on at

    Hi Vaishali,

    With how PowerBI works, even if you are using the APIs to pull data directly from CRM they are run in the context of the user doing the refresh of the dashboard.  In order for the data to be shown in the way a SSRS report does fully in the context of the user they would have to be refreshing the data and then uploading every time.  

    The closest thing you could do is to make it so that you have one base PowerBI report and then create multiple dashboards from it. Then once you have the multiple dashboards one for each organization, and then make it so that by permissions or sharing only people from the correct organization are seeing a specific embedded page or PowerBI Dashboard.  

  • Suggested answer
    Nicholas Hayduk Profile Picture
    Nicholas Hayduk 2,863 on at

    Hello,

    You should be able to use filter parameters to create personalized reports:

    docs.microsoft.com/.../service-url-filters

    This is done by adding query string parameters to the report URL, and since you embed the report by putting in the URL in the Liquid tag, and since you can use Liquid to get the ID of the current user's contact record, it should be possible to craft a report that only shows data related to the current contact record.

    Hope that helps.

    Nick

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans