Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Project Service Automation forum / Power BI Dashboard not...
Project Service Automation forum
Unanswered

Power BI Dashboard not Displaying Data

(0) ShareShare
ReportReport
Posted on by JasonTwi 195

Hi All,

 

I published a Power BI Dashboard to Dynamics 365 Project Service, but when I select the dashboard

it attempts to load data (spinning wheel) but then just goes grey and stops.

I tried a second different dashboard and its the same result (I tried this also as an embedded report 

in an iframe on a standard dashboard and it works).

I tried it with allow everyone security and then custom security but it didn't make a difference.

We have the relevant licenses for viewing.

When I click "open in Power BI" it opens fine without issue.

The report was built in Power BI using the Odata api connection to D365. It was then published to Power BI 

online and added to a dashboard, all of this works.

Any ideas?

Thanks,

Jason

Categories:
Other
  • Daniel Bach Profile Picture
    Daniel Bach 40 on at
    RE: Power BI Dashboard not Displaying Data

    Great news.

    from time to time it is like some magic and after diggin into the problem,

    a good resolution is, wait for a day. There may be some updates running

    or service downtimes.

    Now you could only check in the Health portal if there was some downtime

    in a service and verify if there was any update running in your dynamics environment

    taking a look at system=>solution history using "all solution" view.

    But at the very end, it is working.

  • JasonTwi Profile Picture
    JasonTwi 195 on at
    RE: Power BI Dashboard not Displaying Data

    Thanks, that's excellent

    It started working today! 

    Both Power BI Dashboards came to life today, I checked them this morning and data was showing, so sadly that means

    haven't a clue what the solution is! 

    I didn't do anything to them, so could it have been some kind of system change or maybe 

    a system refresh overnight? 

    Jason

  • Daniel Bach Profile Picture
    Daniel Bach 40 on at
    RE: Power BI Dashboard not Displaying Data

    Hi Jason,

    when it is working in the Power BI Service i would think it is an authentication issue.

    Here is a full docu how to Setup Power BI as an Dashbaord:

    docs.microsoft.com/.../configure-customer-service-analytics-dashboard

    Maybe one little step is missing.

  • apa Profile Picture
    apa 8,280 on at
    RE: Power BI Dashboard not Displaying Data

    Only things I can think of is making sure everyone has pro/premium as license and that they can access the PBI workspace where the report is. Hopefully someone here with more PBI knowledge will pick this up.

  • JasonTwi Profile Picture
    JasonTwi 195 on at
    RE: Power BI Dashboard not Displaying Data

    Hi,

    Added as a system dashboard.

    Jason

  • apa Profile Picture
    apa 8,280 on at
    RE: Power BI Dashboard not Displaying Data

    Are you adding it as a personal dashboard or an embedded system dashboard?

    docs.microsoft.com/.../create-edit-powerbi-embedded-page

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Community Spotlight for September 2024

Kudos to Mohana Yadav!

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,353 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,251 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans