Power BI Connection

(0) Share

Report

Posted on by GRich

Dear Community,

i have the Problem, that i can load my Data from Guides-Instance to Power BI Desktop, but i cannot see or filter the data. I have completed the instructions for several times:

Is it necessary to do some configuration in powerapp admin center, in power bi or guides?

I have done the steps that are written in guides analytics @ guides app.

Thanks a lot for answering

GRich

I have the same question (0)

All responses (15)

Answers (1)

DavePinch on at

Like (0)

Report

Hi GRich,

You should not have to do any special configuration beyond the instructions. First, can you confirm that you have operated a guide in operator mode? You may see the behavior shown in your screenshot if you haven't yet run a guide and generated telemetry. Once you have generated some telemetry, open the PowerBI desktop app and select the data tab as highlighted below. Confirm you see some data.

However, if you don't see data and you know you have generated some telemetry, then there may be an upstream issue. To help diagnose, log into the Guides portal and go to the telemetry tab. Note: if you haven't bookmarkeded your portal, go to your instance URL (found on the Analyze tab of the Guides desktop app) and look for the portal link. Then look for the telemetry link on the left-side menu as shown in the second screen below.

Do you see data here that is not showing up in PowerBI?

Was this reply helpful? Yes No
GRich 45 on at

Like (0)

Report

Hi Dave,

thanks for your answer.

Now I can see the Data from Guides in Power BI as you have described.

In my Charts I cannot see the Data. The connections seen in the picture are done:

Thanks a lot for your help.

Best Regards

GRich

Was this reply helpful? Yes No
Verified answer

DavePinch on at

Like (0)

Report

Thanks GRich. I will reach out to the data engineering team. In the meantime (just so I am very clear), can you explicitly confirm the following:

1. You see data in the Events table and Guides tables, but:

2. No data appears in the Process Tracking report.

3. No data appears in the Guides Usage report.

What happens when you select the filter option on top of the reports (the drop-down on the blue band on the top of the report)? Are your guides listed?

Was this reply helpful? Yes No
GRich 45 on at

Like (0)

Report

Hallo DavePinch,

thanks for your answer. I can answer your questions as following:

1. I see data in Guides and SourceEvents. I have no data in Events and Runs.

2. No data appears in Process Time-Tracking and

3. no data appears in Guides Usage

I can choose all guides step by step advises and the number "Guides" changes, but the rest of the data-boxes are empty.

I do not know my status "guides listed or not". I work in a big company and we have a valid guides license and a valid license for power bi desktop.

Thanks a lot and have a nice day

GRich

Was this reply helpful? Yes No
DavePinch on at

Like (0)

Report

Thanks GRich. No worries on "guides listed or not" - I wanted to know if you could see your guides in the drop-down menu (and it appears you can.) Last thing - my apologies but I am not clear from the thread. Can you confirm that you have used your guides as an operator - by this I mean opening the guide on the HoloLens and using the guide as an operator (not an author). The report is filtered to show events from operator mode.

Was this reply helpful? Yes No
GRich 45 on at

Like (0)

Report

Hallo DavePinch, no problem.

Yes I did the most of the guides for several times in operator mode.

Perhaps you have further ideas. Maybe we also can have a teams call that i can show it to you.

Thanks a lot and have a nice day.

GRich

Was this reply helpful? Yes No
Suggested answer

DavePinch on at

Like (0)

Report

Thank you GRich and no worries, we will get this solved. Let's try one more thing. There is a known issue in older versions of the report in which authors acting as operators do not appear. This was fixed in July in version 1.0.0.3 of the report. To confirm you are on this version, go to the Getting Started tab and look for the small version number in the lower-left corner. If you are on an older version, download the latest template from https://www.microsoft.com/en-us/download/details.aspx?id=57767 and try again.

Was this reply helpful? Yes No
GRich 45 on at

Like (0)

Report

Hallo Dave,

thank you for the answer. I have downloaded the new Version 1.0.0.3 and when i want to start it with my power bi desktop i geht the following mistake:

"Fehler beim Speichern von Änderungen auf dem Server. Zurückgegebener Fehler: "Der Ausdruck in der Partition "n/a" in Tabelle "n/a" verweist auf eine unbekannte Entität"

Was this reply helpful? Yes No
DavePinch on at

Like (0)

Report

Thank you for trying - and thank you for your patience! Let's go with your suggestion and do a Teams call with engineering. I sent you a private message on this forum to start coordination. Once fixed, we can return back to this thread and post any useful information to others in the community.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

This thread is really helpful since I have the same problem as GRich where my data cannot load from my guides to the power Bi desktop. Therefore, I would be really grateful if you can share and finish this thread with the solutions that both of you have discussed.

Have a nice day and thank you so much :)

Was this reply helpful? Yes No