microsoft / powerbi-loganalytics-template-reports Goto Github PK

The repository hosts Power BI template files that can be used to analyze Power BI data after you send it to Azure Log Analytics.

License: MIT License

PowerShell 100.00%

powerbi-loganalytics-template-reports's Introduction

Power BI Log Analytics Template Reports

Power BI allows users to configure connections to Azure Log Analytics where they can retain detailed historical activity data. This repo hosts Power BI Templates (.pbit) reports that you can point to your Azure Log Analytics workspaces to load data and get insights.

Available templates:

Fabric Analysis Services Engine Analytics report template: This template adds the model layer to the ocean of the Analysis Services engine trace events and enables you to go from data to insight to action quickly.
Log Analytics for Analysis Services Engine report template: This template allows you to visualize the activity of datasets hosted in the Analysis Services Engine in Power BI workspaces. You can use it to identify load patterns, investigate user actions, look at query performance trends, visualize refreshes, and much more!

Contributing

This project welcomes contributions and suggestions. Most contributions require you to agree to a Contributor License Agreement (CLA) declaring that you have the right to, and actually do, grant us the rights to use your contribution. For details, visit https://cla.opensource.microsoft.com.

When you submit a pull request, a CLA bot will automatically determine whether you need to provide a CLA and decorate the PR appropriately (e.g., status check, comment). Simply follow the instructions provided by the bot. You will only need to do this once across all repos using our CLA.

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact [email protected] with any additional questions or comments.

Trademarks

This project may contain trademarks or logos for projects, products, or services. Authorized use of Microsoft trademarks or logos is subject to and must follow Microsoft's Trademark & Brand Guidelines. Use of Microsoft trademarks or logos in modified versions of this project must not cause confusion or imply Microsoft sponsorship. Any use of third-party trademarks or logos are subject to those third-party's policies.

powerbi-loganalytics-template-reports's People

Contributors

Stargazers

Watchers

Forkers

karthikinv thedatacrew bimal2810 samaguire aghonaim ievsantillan isantillan1 jsmallwood firetom5900 kim-haymon-swi edson-github cdrguru test-mass-forker-org-1 isabella232 zahidsqldba07 kevarnold972 ruiromano erinmcglew tangoalphakilo virtua-health-system stbere hemakumargantepalli armadh hexabytetech richardsonjf lponnam75 stversch nax199x fbobczuk kiddojazz johndev13 syedyousufsohail colinpeacock1 msbelindaallen prudviraj007 jwryan-bham haidonghuang-microsoft xiaozhangms rakshannagesh0526 kumarcpt25

powerbi-loganalytics-template-reports's Issues

1 potential issue and 2 questions

Hi dears contributors

Firstly , great thanks for this useful APP, all my PBI administrator around premium troubleshooting colleagues like

Perhaps a small issue : It is missing scenario = "query completed" on Query Statistics page whole page filters

2 questions :

What is the meaning of all these operations you display , please
I understand queryEnd , CommandEnd (type refresh) , error ... I don't know DiscoverEnd ;>)

operation | operation detail | scenario name

There are some difference between logs analytics data and App Fabric metrics underlying table KPIs
Perhaps it's normal because telemetry systems are not the same

--Small differences around SUM(CU) aggregations
Perhaps it' normal due to (X reasons - logs method etc ..)
Thanks a lot if you have hear something on the subject

--Big differences regarding operation counts

Update template to support multiple Power BI workspaces

Hi, the Azure Log Analytics integration with Power BI now support workspace logs from multiple Power BI workspaces sent to a dedicated Log Analytics workspace.

It would be great if the template could be updated to support the new properties:

PowerBIWorkspaceId
PowerBIWorkspaceName

Thanks

Add Report Names support

Would be great to have the report names instead of the GUIDs.
Maybe this could be obtained from Power BI API and then joined together?

Sensitivity label can't be verified

I am getting "the sensitivity label cannot be verified" error when I try to open the template.

Error 400: Bad Request

Hello - I am attempting to use this Power BI PBIT file. When I enter my Log Analytics Workspace Id and attempt to load data, I get a Error 400: Bad Request error. This is occurring on the Suboperation - Query step

When I paste the URL it is attempting to execute in my browser, I see this:

{"error":{"message":"Valid authentication was not provided","code":"AuthorizationRequiredError","correlationId":"8055813b-9e2a-4a5c-b316-33a2394294bb"}}

I am never prompted for any sort of authentication. How do I get around this?

Measure User DCount

The measure "User DCount" should be DISTINCTCOUNT (Operation[Executing User] ).

Logging for Analysis Service

I understand this report is made for powerBI. But when setting up LogAnalysis in Azure for Azure Analysis Service, would it be possible to use (some) of the report for analyzing processing and queries as well? I am not at all familiar with Kusto, so I am hoping to get some help on what queries to tweak?

Or as an alternative, is there somewhere a report in PBI made for analyzing Azure Analysis Service Logs as well?

Thank you for you help!

Support for PowerBIDatasetsTenant

The endpoint for PowerBIDatasetsTenant has been available in Log Analytics for a while. Is there a roadmap for when data will be available here and whether this report will be updated to support?

Can't open the pbit-file: "Either the file is encrypted or corrupted."

I've downloaded the pbit on 3 different computers now. It fails like this when opening the file in the Aug23 version of PBI Desktop. Am I doing something wrong?

Metrics discrepancy.

The metrics created for this code are different vs the metrics from Usage Metrics Report provided for Power BI tool.
For example many actions IDs are lost, so we are under reporting metrics.

restricted to use

i try to open the template, it says "file is restricted with sensitivity label"

ReportName and Workspace Name are not reflecting in the table visuals - Log Analytics template

ReportName and Workspace Name are not reflecting in the table visuals - Log Analytics template
Could you please let me know by when this can be fixed. Also, when would be the next release of this template.

Error while loading data using Power BI template

Cannot open the PowerBI Desktop Project

Problem: Power BI Desktop is choking on the editor settings in the .pbi hidden folder
Solution: Delete the .pbi folder and the report loads normally

Duplicating WS's and data

Log Analytics Report data Workspaces monitored under each capacity are duplicating same data...

Unable to Analyze in Excel

I am a workspace admin so would expect to be able to use Analyze in Excel and Export To Excel with a live connection to the dataset created by this template since I have the build permission. However the only thing I'm able to do is export summarized data to CSV. Is this intentional? is it documented anywhere?

Analyze in Excel is greyed out:

When I Export To Excel with a live connection and authenticate, i see this message: