Forum Discussion

samcogan's avatar
samcogan
New Member
9 years ago

Analysing point in time data

I'm hoping someone can tell me if this is even possible before I spend a lot of time looking at it. I am trying to report on teh uptime of a service running in Azure, we are collecting data using log...
Need Help
CahabaData's avatar
CahabaData
Memorable Member
9 years ago

there is a DateAdd function in DAX so that you can establish the time interval between event times - and then graph that.  You posted in Service and this data modeling would really need to occur in Desktop and then publish the report to service.

 

it doesn't sound like you want a daily plot - but that could be established by adding a Calendar table.

 

 

 

samcogan's avatar
samcogan
New Member
9 years ago
Ok thanks, we're using the service as the data we are using is pushed there directly by a connector in Azure so it's only accessible in the service. I guess to use the desktop version I'd need to get it into a database or similar and then use that?
  • CahabaData's avatar
    CahabaData
    Memorable Member
    9 years ago

    while I tend to think it would be best modeled in desktop - - there are others here at the community that are more advanced at doing things at the Service so I would defer to them - - hopefully one will visit this post and contribute...

     

    desktop can connect and auto refresh to Azure with a gateway - so no 3rd db is going to be involved.... one can proto type with a manual Get Data before installing the gateway as a sanity test that the linking is capabile but since you have it already at Service then it is a high probable to be okay....

     

    you also may download your Service report to a desktop pbix file though not sure if that offers a gain.....