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
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 ID | Session ID | Event Datetime | Logon | Client Type | Database Name |
1227 | 52 | 28/10/2017 10:01 | Logon | 0 | ActeonNAV |
1227 | 52 | 28/10/2017 10:41 | Logoff | 0 | ActeonNAV |
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
Solved! Go to Solution.
Here is a similar case. You may have a look.
https://community.powerbi.com/t5/Desktop/Trend-from-History-Table/td-p/199565
Here is a similar case. You may have a look.
https://community.powerbi.com/t5/Desktop/Trend-from-History-Table/td-p/199565
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |