Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Guides forum / Error when opening in ...
Guides forum

Error when opening in PowerBI to output Guide report

(0) ShareShare
ReportReport
Posted on by Shota 5


About error when outputting Power BI report of Dynamics365 Guides I tried running Dynamics365 Guides with HoloLens, so when I tried to output a report with Power BI, I got a loading error.

Analyze guides created with Dynamics 365 Guides in preview: https://docs.microsoft.com/en-us/dynamics365/mixed-reality/guides/analytics-guide

According to this procedure, I opened the Guides Analytics Template, entered the URI, and when I read it, I got an image error. I do not know how to investigate the cause

? This is the content of the image

  •  Guides
    • The read was canceled because an error occurred while reading the previous table.
  • SourceEvents
    • The read was canceled because an error occurred while reading the previous table.
  •  Events
    • OLE DB or ODBC error: [Expression.Error] Type can not be converted to Record type.

    PowerBI_5F00_LoadError.png

Categories:
General
  • Suggested answer
    Shota Profile Picture
    Shota 5 on at
    RE: Error when opening in PowerBI to output Guide report

    Greate thanks!

    The problem has been solved.

  • Verified answer
    MaheshKamat Profile Picture
    MaheshKamat on at
    RE: Error when opening in PowerBI to output Guide report

    Hi Shota - we just released a fix to the PowerBI report template for this issue at https://aka.ms/guidesreport. The report would show this error if some values had NULL. We are not sure why this might be occurring at your end, as we don't see this issue on released builds. However, you should be able to look at your data with this new template. Note that some usage might be missing as we would filter those out for the report to work. We can assist with further questions if you see additional issues.

  • Shota Profile Picture
    Shota 5 on at
    RE: Error when opening in PowerBI to output Guide report

    Thank you for your reply! And thank you for action to solve the problem.

    I couldn't demo until the end due to this error.

    I hope this problem is resolved.

  • MaheshKamat Profile Picture
    MaheshKamat on at
    RE: Error when opening in PowerBI to output Guide report

    Hi there,

    We did some investigation on this issue and it appears that this occurs when some fields that should propogate into the PowerBI report are not piping through. We are currently investigating a fix to this issue. 

    We're really sorry for the inconvenience this is causing. I will post back to this thread once we have a resolution or workaround.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,431 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,503 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans