Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am getting, error in datasource setting, when I deployed report at Power BI Service, as "You can't schedule refresh for this dataset because the following data sources currently don't support refresh: Data source for Query1 Discover Data Sources"
I am getting this error, w.r.t. data source which is querying Azure-Monitor Log.
let me give you some more info.
If I try to use relative path, query is syntactically error out.
I am not expert, so not sure how to proceed ?
Please find my parameterized M code (without relative path) below. It works locally but not on PBI Service.
==============================================
let
Source = (SubscriptionId as any) => let AnalyticsQuery =
let Source = Json.Document(Web.Contents(https://api.loganalytics.io/v1/subscriptions/&SubscriptionId&"/query",
[Query=[#"query"="Event
| where Source == ""MyTasksService"" or Source ==""Service Control Manager""
| where RenderedDescription contains ""XYZ"" and RenderedDescription contains ""stopped""
| order by TimeGenerated asc
| project TimeGenerated, Computer, RenderedDescription, _SubscriptionId
",#"x-ms-app"="AzureFirstPBI",#"timespan"="P1D",#"scope"="hierarchy",#"prefer"="ai.response-thinning=true"],Timeout=#duration(0,0,4,0)])),
TypeMap = #table(
{ "AnalyticsTypes", "Type" },
{
{ "string", Text.Type },
{ "int", Int32.Type },
{ "long", Int64.Type },
{ "real", Double.Type },
{ "timespan", Duration.Type },
{ "datetime", DateTimeZone.Type },
{ "bool", Logical.Type },
{ "guid", Text.Type },
{ "dynamic", Text.Type }
}),
DataTable = Source[tables]{0},
Columns = Table.FromRecords(DataTable[columns]),
ColumnsWithType = Table.Join(Columns, {"type"}, TypeMap , {"AnalyticsTypes"}),
Rows = Table.FromRows(DataTable[rows], Columns[name]),
Table = Table.TransformColumnTypes(Rows, Table.ToList(ColumnsWithType, (c) => { c{0}, c{3}}))
in
Table
in AnalyticsQuery
in
Source
==========================================================
Hi @Anonymous
Can you share how did you generate the relative path for it?
Regards,
Community Support Team _ Jing
let
Source = (SubscriptionId as any) => let AnalyticsQuery =
let Source = Json.Document(Web.Contents("https://api.loganalytics.io/v1/subscriptions" ,[RelativePath = "/"&SubscriptionId&"/query",
Query=[#"query"="Event
| where Source == ""XYZ""
| where RenderedDescription contains ""ABC"" and RenderedDescription contains ""stopped""
| order by TimeGenerated asc
| project TimeGenerated, Computer, RenderedDescription, _SubscriptionId
",#"x-ms-app"="AzureFirstPBI",#"timespan"="P1D",#"scope"="hierarchy",#"prefer"="ai.response-thinning=true"],Timeout=#duration(0,0,4,0)])),
TypeMap = #table(
{ "AnalyticsTypes", "Type" },
{
{ "string", Text.Type },
{ "int", Int32.Type },
{ "long", Int64.Type },
{ "real", Double.Type },
{ "timespan", Duration.Type },
{ "datetime", DateTimeZone.Type },
{ "bool", Logical.Type },
{ "guid", Text.Type },
{ "dynamic", Text.Type }
}),
DataTable = Source[tables]{0},
Columns = Table.FromRecords(DataTable[columns]),
ColumnsWithType = Table.Join(Columns, {"type"}, TypeMap , {"AnalyticsTypes"}),
Rows = Table.FromRows(DataTable[rows], Columns[name]),
Table = Table.TransformColumnTypes(Rows, Table.ToList(ColumnsWithType, (c) => { c{0}, c{3}}))
in
Table
in AnalyticsQuery
in
Source