Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Rabacov
Regular Visitor

Display Active NAV licenses over time

Hello all,

 

I wonder if anyone could help with this. The IT team from the company I work for are currently looking into building a Power BI Dashboard and display the number of active Microsoft NAV active licenses at any given point in time. 

 

I managed to find a SQL table on NAV that has the following columns:

 

Server Instance IDSession IDEvent DatetimeLogonClient TypeDatabase Name
12275228/10/2017 10:01Logon0ActeonNAV
12275228/10/2017 10:41Logoff0ActeonNAV

 

For every Session ID, there is a Logon and Logoff time. I then created a new column with SQL called "duration" which is basically doing "logoff time - logon time". This would indicate how long that Session ID was active for. 

 

I wonder now how is the best way to go about creating this graph with Power BI? This should be a line chart that would show the number of active licenses over time. In other words I would be using a count of Session ID for anytime this comes active at any given point in time. 

 

Any ideas? 

 

Thanks in advance

Best

Eric

 

 

1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@Rabacov,

 

Here is a similar case. You may have a look.

https://community.powerbi.com/t5/Desktop/Trend-from-History-Table/td-p/199565

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-chuncz-msft
Community Support
Community Support

@Rabacov,

 

Here is a similar case. You may have a look.

https://community.powerbi.com/t5/Desktop/Trend-from-History-Table/td-p/199565

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.