microsoft / PowerBI-LogAnalytics-Template-Reports

The repository hosts Power BI template files that can be used to analyze Power BI data after you send it to Azure Log Analytics.
MIT License
107 stars 44 forks source link

Error 400: Bad Request #5

Open randyminder opened 2 years ago

randyminder commented 2 years ago

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?

samaguire commented 2 years ago

I'm having similar trouble with the template app from the market within the service. Auth must've changed in the last week and the app / this template need to be updated... I was going to download this template and verify, but will wait instead...

natekist commented 2 years ago

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?

I'm seeing the same issue when setting up the app. I tried to download the template from this GIT and reconfigure but I received the same error. Could it be an update is causing an error in the Kusto query?

natekist commented 2 years ago

Through debugging the kusto code it seems the "PowerBIDatasetsWorkspace" table in the log analytics workspace no longer has the "WorkspaceId" and "WorkspaceName" fields. I was able to get the report working by deleting the references to these fields in each of the kusto queries

This code returned an error while debugging in the log analytics workspace window PowerBIDatasetsWorkspace | where TimeGenerated >= datetime("7-11-2022") and TimeGenerated < datetime("7-12-2022") | where (OperationName == 'AggregateTableRewriteQuery') | extend TextDataHash = hash(EventText) | extend DurationMs = coalesce(DurationMs, 0) | extend User = User | extend ExecutingUser = ExecutingUser | distinct ApplicationName, CpuTimeMs, ArtifactId, ArtifactName, ArtifactKind, DatasetMode, DurationMs, EventText, ExecutingUser, OperationDetailName, OperationName, PremiumCapacityId, SourceSystem, Status, StatusCode, TenantId, TextDataHash, TimeGenerated, Type, User, XmlaRequestId, XmlaSessionId, XmlaObjectPath, _ResourceId, _SubscriptionId | project ApplicationName, CpuTimeMs, DatasetId = ArtifactId, Dataset = ArtifactName, ArtifactKind, DatasetMode, ['Duration (ms)'] = DurationMs, EventText, ExecutingUser, OperationDetailName, OperationName, PremiumCapacityId, SourceSystem, Status, StatusCode, TenantId, TextDataHash, TimeGenerated, Type, User, WorkspaceId, WorkspaceName, XmlaRequestId, XmlaSessionId, XmlaObjectPath, ResourceId = _ResourceId, SubscriptionId = _SubscriptionId, StartTime = TimeGenerated

while this executes without error PowerBIDatasetsWorkspace | where TimeGenerated >= datetime("7-11-2022") and TimeGenerated < datetime("7-12-2022") | where (OperationName == 'AggregateTableRewriteQuery') | extend TextDataHash = hash(EventText) | extend DurationMs = coalesce(DurationMs, 0) | extend User = User | extend ExecutingUser = ExecutingUser | distinct ApplicationName, CpuTimeMs, ArtifactId, ArtifactName, ArtifactKind, DatasetMode, DurationMs, EventText, ExecutingUser, OperationDetailName, OperationName, PremiumCapacityId, SourceSystem, Status, StatusCode, TenantId, TextDataHash, TimeGenerated, Type, User, XmlaRequestId, XmlaSessionId, XmlaObjectPath, _ResourceId, _SubscriptionId | project ApplicationName, CpuTimeMs, DatasetId = ArtifactId, Dataset = ArtifactName, ArtifactKind, DatasetMode, ['Duration (ms)'] = DurationMs, EventText, ExecutingUser, OperationDetailName, OperationName, PremiumCapacityId, SourceSystem, Status, StatusCode, TenantId, TextDataHash, TimeGenerated, Type, User, XmlaRequestId, XmlaSessionId, XmlaObjectPath, ResourceId = _ResourceId, SubscriptionId = _SubscriptionId, StartTime = TimeGenerated

samaguire commented 2 years ago

Yes, I found the same thing.

https://community.powerbi.com/t5/Service/Power-BI-Log-Analytics-for-Analysis-Services-Engine-Refresh/m-p/2619434/highlight/true#M165540

You should raise a support ticket. (Which is what I've done now.)

bstar92 commented 2 years ago

Hi, I can confirm that the issue has been resolved in the latest PBIT. Please let me know if you have any further questions.

Thanks, Bogdan

samaguire commented 2 years ago

@bstar92 Is the template app going to be updated? https://appsource.microsoft.com/product/power-bi/pbi_pcmm.powerbiloganalyticsforasengine

randyminder commented 2 years ago

How does the template app in Appsource differ from what is in Github?

From: Stephen Maguire @.> Sent: Wednesday, July 20, 2022 5:44 PM To: microsoft/PowerBI-LogAnalytics-Template-Reports @.> Cc: Randy Minder @.>; Author @.> Subject: Re: [microsoft/PowerBI-LogAnalytics-Template-Reports] Error 400: Bad Request (Issue #5)

CAUTION:

This email originated from outside FirstKey Homes. Do not click links or open attachments unless you recognize the sender and are expecting the information

Is the template app going to be updated? https://appsource.microsoft.com/product/power-bi/pbi_pcmm.powerbiloganalyticsforasenginehttps://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fappsource.microsoft.com%2Fproduct%2Fpower-bi%2Fpbi_pcmm.powerbiloganalyticsforasengine&data=05%7C01%7Crminder%40firstkeyhomes.com%7C13edf86bdcbc4dde1f4108da6a98ea5f%7Caa33e5f200dd407eb3378cb00f28c25d%7C0%7C0%7C637939502256614343%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=7x26%2B2LwXc5R5Xp0hia9K0dJNj3S%2B03mr2938wz8rpA%3D&reserved=0

- Reply to this email directly, view it on GitHubhttps://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fmicrosoft%2FPowerBI-LogAnalytics-Template-Reports%2Fissues%2F5%23issuecomment-1190787106&data=05%7C01%7Crminder%40firstkeyhomes.com%7C13edf86bdcbc4dde1f4108da6a98ea5f%7Caa33e5f200dd407eb3378cb00f28c25d%7C0%7C0%7C637939502256614343%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Yimd4Ow3AXeVovowH1LFFpDeXDW%2BGdfbmciWgObQFC4%3D&reserved=0, or unsubscribehttps://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAXVPU7DWCUO5SBECVVXBRS3VVBXI3ANCNFSM52J4WYVQ&data=05%7C01%7Crminder%40firstkeyhomes.com%7C13edf86bdcbc4dde1f4108da6a98ea5f%7Caa33e5f200dd407eb3378cb00f28c25d%7C0%7C0%7C637939502256614343%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=qfuCiMDN%2F7RK3zW3WhkbgiYyBHWkXs7J9vMYZttXD5M%3D&reserved=0. You are receiving this because you authored the thread.Message ID: @.**@.>>

samaguire commented 2 years ago

How does the template app in Appsource differ from what is in Github? From: Stephen Maguire @.> Sent: Wednesday, July 20, 2022 5:44 PM To: microsoft/PowerBI-LogAnalytics-Template-Reports @.> Cc: Randy Minder @.>; Author @.> Subject: Re: [microsoft/PowerBI-LogAnalytics-Template-Reports] Error 400: Bad Request (Issue #5) CAUTION: This email originated from outside FirstKey Homes. Do not click links or open attachments unless you recognize the sender and are expecting the information Is the template app going to be updated? https://appsource.microsoft.com/product/power-bi/pbi_pcmm.powerbiloganalyticsforasenginehttps://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fappsource.microsoft.com%2Fproduct%2Fpower-bi%2Fpbi_pcmm.powerbiloganalyticsforasengine&data=05%7C01%7Crminder%40firstkeyhomes.com%7C13edf86bdcbc4dde1f4108da6a98ea5f%7Caa33e5f200dd407eb3378cb00f28c25d%7C0%7C0%7C637939502256614343%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=7x26%2B2LwXc5R5Xp0hia9K0dJNj3S%2B03mr2938wz8rpA%3D&reserved=0 - Reply to this email directly, view it on GitHubhttps://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fmicrosoft%2FPowerBI-LogAnalytics-Template-Reports%2Fissues%2F5%23issuecomment-1190787106&data=05%7C01%7Crminder%40firstkeyhomes.com%7C13edf86bdcbc4dde1f4108da6a98ea5f%7Caa33e5f200dd407eb3378cb00f28c25d%7C0%7C0%7C637939502256614343%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Yimd4Ow3AXeVovowH1LFFpDeXDW%2BGdfbmciWgObQFC4%3D&reserved=0, or unsubscribehttps://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAXVPU7DWCUO5SBECVVXBRS3VVBXI3ANCNFSM52J4WYVQ&data=05%7C01%7Crminder%40firstkeyhomes.com%7C13edf86bdcbc4dde1f4108da6a98ea5f%7Caa33e5f200dd407eb3378cb00f28c25d%7C0%7C0%7C637939502256614343%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=qfuCiMDN%2F7RK3zW3WhkbgiYyBHWkXs7J9vMYZttXD5M%3D&reserved=0. You are receiving this because you authored the thread.Message ID: @.**@.>>

It isn't working either - same error.

bstar92 commented 2 years ago

@bstar92 Is the template app going to be updated? https://appsource.microsoft.com/product/power-bi/pbi_pcmm.powerbiloganalyticsforasengine

Hi, the template App will also be updated shortly to reflect the issue.