Tracing with Log Analytics and Power BI

No video

Tracing with Log Analytics and Power BI

Рет қаралды 37,638

3 жыл бұрын

With Log Analytics integration in Power BI, you can now capture Analysis Services trace events easily and over a longer period of time. Combined with the Power BI template report, you can gain a lot of insights into usage of your datasets. With more to come down the road!
Announcing long-term usage and performance insights (Public Preview)
powerbi.micros...
Using Azure Log Analytics in Power BI (Preview)
docs.microsoft...
📢 Become a member: guyinacu.be/me...
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/co...
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com...
#PowerBI #LogAnalytics #GuyInACube

Пікірлер: 31

@raviv5109 3 жыл бұрын

Form where can we get the PBIX file which you showed?

@hugomancera9330 3 жыл бұрын

This is BANANAS !!!!

@Milhouse77BS 3 жыл бұрын

I'm worried about the cost of Log Analytics. For monitoring my Azure Analysis Services (AAS), it log's a LOT of data, and the cost was more than we wanted to pay.

@billmanassas7746 2 жыл бұрын

Maybe shorthening the retention period of the log analytics would help.

@Milhouse77BS 2 жыл бұрын

@@billmanassas7746 we moved the query logs to cheap ADLS and the CPU logs in Log Analytics since smaller for like a month.

@noahhadro8213 Жыл бұрын

@@Milhouse77BSso if I understand correctly you are moving the log analytics logs to ADLS for retention and only keeping 30 days in log analytics? Trying to find ways to save on costs

@Milhouse77BS Жыл бұрын

@@noahhadro8213 Yes, We keep the CPU/Memory metrics in Log Analytics for 60 days, and query logs and metrics stored permanently in ADLS

@122Mime 2 жыл бұрын

Hi Adam, thanks for the video! Were you able to connect to the Data source when using the template? I struggle to find the correct authentification method.

@AndyKabeer Жыл бұрын

Hi, great video, is it possible to track what filter conditions were used while running a report (especially time filter ) by a user using an audit log?

@guruprasadmathapati6519 Ай бұрын

Q Hello Adam, it is very much informative video. My question is can we take some part of log analytics and build customise dashboard in Power BI?

@noahhadro8213 Жыл бұрын

To save on costs can I limit what I want to bring into log analytics? On a profiler trace can’t you pick what you want to trace? Can you do the same with the log analytics connection. Or is it all or nothing from a workspace?

@SL4MUEL 3 жыл бұрын

How do you create the horizontal page navigation menu across the top? The currently selected page underline and hover features.

@dimansocial 2 жыл бұрын

Great! Thank You!

@rubenkamphorst1646 2 жыл бұрын

Thanks for the video, I've one question regarding the update of the data. Is there any possibility to make this streaming / near real-time?

@benjaminmartin8646 3 жыл бұрын

Can your channel cover alternative solutions to the issue that we cannot drill down across multiple tables? Thanks!

@jordanfox470 2 жыл бұрын

In Log Analytics, PowerBIDatasetsTenant exists, but there's no data being piped to it. Any idea when/if this will exist?

@aravindadamarla Жыл бұрын

Hello..can you point me to the link to powerbi report template?

@TobeEzeife 2 жыл бұрын

Anyone know if the report name is accessible from the dataset as opposed to the report_id?

@kieranwhelan6794 3 жыл бұрын

Hi Guys, do you have any recommendations on laptops to use? I am going to be starting out consulting next year and can't use my organisations laptop but it is quite slow on PBI anyway!

@AlbertoGastaldo 3 жыл бұрын

Nice stuff. do you know if it also works when my reports are connected to an on-prem SSAS dataset (via gateway) ? In other words, I need usage metrics (how many times a report was opened or edited) rather than query statistics which I can collect on my SSAS box. Thsnks! Alberto

@johanneshiller4306 3 жыл бұрын

I have search a lot. Is there a pbit file or not?

@utuberay007 Жыл бұрын

Also since it’s a year and now this log analytics could be GA , a new video will help latest features

@PortogasDZ7 3 жыл бұрын

How do you create the section of filters values, like 9:30 at the top (I can see the selected values of the slicers Date, Premium capacity, Dataset, Report Id, and Scenario)?

@pankajsonawane3958 3 жыл бұрын

Using smart narrative visual.

@PortogasDZ7 3 жыл бұрын

@@pankajsonawane3958 thank you!

@utuberay007 Жыл бұрын

Can you share the pbit azure services report t 8:27 ?link or info where to get

@utuberay007 Жыл бұрын

Ref t8:27