Hello,
Goal: generate graphs to show our app insights data such as % processor time averaged daily
We have about 30.1 million records for perf counters in an Azure SQL DB. I'm new to power bi and I couldn't understand in the UI how to do a datediff to have it group by daily periods and average the value.
I have a stored proc that I use in SQL:
select
DATEADD(day, T2.DailyPeriods, '2016-01-01T00:00:00') as Date,
T2.AvgValue
FROM
(
select
T1.DailyPeriods,
AVG(T1.val) as AvgValue
From
(
select
datediff(DAY, '2016-01-01T00:00:00',[eventTime]) AS DailyPeriods,
[value] AS val
from
dbo.[PerformanceCounters]
WHERE [instance] = '_Total'
)
as T1
GROUP BY T1.DailyPeriods
)
T2
order by Date
when I try to load that through the dq option I get "the order by clause is invalid in views, inline funcitons... unless top offser or for xml is also specified"
Your assistance is appreciated.
