I have installed the Power BI Log Analytics for Analysis Services Engine in order for us to analyze our Power BI service. When I attempt to refresh, it will run for 3-5 minutes and then abort with an error 400: Bad Request. Has anyone encountered this error and resolved it?
I'm having the same issues in my tenant as well. It had been running perfectly since the public preview came out. There are a few things going on:
'distinct' operator: Failed to resolve scalar expression named 'WorkspaceId'
| where TimeGenerated between(datetime("2022-06-19 00:00:00") .. datetime("2022-06-26 23:59:59"))
// | extend Sources = parse_json(ApplicationContext).Sources
// | mv-expand Sources
// | extend ReportId = tostring(parse_json(Sources).ReportId)
// | extend TextDataHash = hash(EventText)
// // | extend DurationMs = coalesce(DurationMs, 0)
// // | extend User = iff(toupper(WorkspaceId) in (workspaceIdList), hash_md5(User), User)
// // | extend ExecutingUser = iff(toupper(WorkspaceId) in (workspaceIdList), hash_md5(ExecutingUser), ExecutingUser)
// | distinct ApplicationName, CpuTimeMs, ArtifactId, ArtifactName, ArtifactKind, DatasetMode, DurationMs, EventText, ExecutingUser, OperationDetailName, OperationName, PremiumCapacityId, ReportId, SourceSystem, Status, StatusCode, TenantId, TextDataHash, TimeGenerated, Type, User, WorkspaceId, WorkspaceName, XmlaRequestId, XmlaSessionId, _ResourceId, _SubscriptionId
| summarize events_count = count() by bin(TimeGenerated, 1d)
| order by events_count asc
How am I refreshing? Do you know anything about this report? There are 2 ways to do a refresh. 1) When the app is first installed it will tell you that sample data is being used and a link is provided to do a refresh. 2) Refresh the dataset like any other dataset.
GilbertQ - Do you know anything about the Power BI Log Analytics for Analysis Services Engine app? It sounds like you might not. This is ok. I would just rather deal with someone who knows about this app and how to deal with this error. The error occurs when I click the Refresh link to refresh the dataset associated with the report.
It is only now that you specified that you are talking about the Power BI Log Analytics App. Before that you did not specify it, and that is what I was looking to understand what and how you were refreshing.
If there is an error with the app you would need to log a support ticket because this is supported by Microsoft.
The other option is to log into the Azure Portal and connect to the Log Analytics workspace directly. This is what I have done in the past and works very well for me.
Can I confirm that you have created the log analytics in your Power BI Premium/PPU App Workspace?
And then have you tried to query it in Log Analytics in the Azure Portal?
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Watch Session 24 of Ted's Dev Camp along with past sessions!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.