Building a Power BI Admin View [Part 3]: User Activity Data!

No video

Building a Power BI Admin View [Part 3]: User Activity Data!

Рет қаралды 25,820

Күн бұрын

Part 3 of the Power BI Admin Report series covers how to obtain user activity data! We need to call the Power BI API recursively to get all of the data back. In the next part, we'll visualize all of the data from the previous 3 parts!
Blog post with code: bielite.com/bl...
Admin View Part 2: • Building a Power BI Ad...
Looping in PowerQuery: • Easy Looping in Power ...
----------------------------------------------------------------------------------------------------
To enroll in my introductory or advanced Power BI courses:
training.bieli...
Elite Power BI Consulting:
bielite.com/
Data Insights Tools:
www.impktful.com/
Connect with me on Twitter!
/ powerbielite

Пікірлер: 30

@richardconley5343 3 ай бұрын

Seriously wish you still did training.

@singhrakeshr 4 жыл бұрын

I have been trying to get this working in dataflow with no success.. will follow your video n see.. thanks for sharing

@jefflingen8819 3 жыл бұрын

Part 4 coming soon? Curious to see effective ways to visualize this great data.

@hussamamal 2 жыл бұрын

This is incredible.

@raybrosius8220 2 жыл бұрын

This series is awesome.. I was able to make it all work.. However, I can't go back past 30days.??? We have Premium Per User licenses.. I could not find where the "lookback" timeframe is documented..

@slinktus 2 жыл бұрын

Really Cool series Thank you. I heard somewhere it can be possible to top up a table with API data. Told they made a table then as a part of the API they reference the data table and if a record exists they don't download, if it doesn't exist it returns the value then tops up the original data table. Any thoughts on how this is possible?

@mojgantaheri6456 2 жыл бұрын

How it is possible to get data source? Thank for all amazing vieo

@pratheebanc6439 4 жыл бұрын

Hi, I'm unable to refresh the dataset in power bi service... Getting 404 error. Since it is using bearer token, I have set anonymous type in power bi service but it is not refreshing. Request you to provide your input on how to do scheduled refresh of the dataset.. Thank you in advance

@madhan7390 3 жыл бұрын

Even i am facing the same problem.. Did you get the solution on how to schedule refresh the dataset?

@armstee1 3 жыл бұрын

@@madhan7390 DID YOU GET A SOLUTION TO THE SCHEDULE REFESH ISSUE

@madhan7390 3 жыл бұрын

@@armstee1 No

@armstee1 3 жыл бұрын

Am able to refresh on my desktop but get error in the pbi service

@SamMitchum 4 жыл бұрын

This is excellent, do you have to be admin to gain access to this view? Going to the docs page I'm receiving a 401 error.

@BIElite 4 жыл бұрын

Hi Sam, yes you do need to be an admin. The API endpoints we are covering in this series are a part of the Admin section of the API.

@SamMitchum 4 жыл бұрын

@@BIElite excellent, thank you!

@preetijoshi2035 2 жыл бұрын

whats in the GET Access Token function ? I don't see that anywhere on the vidio ?

@adelistiawan6978 2 жыл бұрын

do you have the answer? because I'm just stuck at this step

@johanabarrera1358 2 жыл бұрын

This is great. Unfortunately I'm getting the error ": Access to the resource is forbidden." and I tried different options in the data source settings but none of them works. Any idea why or what kind of permissions I need to set up. Thanks

@peterg4130 4 ай бұрын

@johanabarrera1358 that's answered in part 1. You need Fabric admin access.

@drewtheberer9978 2 жыл бұрын

What are the limits on a time frame for data retrieval? I'm currently building out a dashboard for covering the reports, users, and the number of times a report is used, etc, and am wanting to grab data since the inception of the PBI Report Server (roughly 2ish years). Is this the best method or is there a better method to getting that data for reporting?

@EdgardoCervantesP Жыл бұрын

A single date, 24 hours.