Notification

Icon
Error

Lansweeper --> PowerBI - Connecting Lansweeper to PowerBI

Posted: Friday, June 15, 2018 3:52:08 PM(UTC)
mikerennie

mikerennie

Member Original PosterPosts: 1
0
Like
Has anyone been able to connect Lansweeper to PowerBI to generate dashboards and what not?

If so, how did you go about it?

Thanks!
Esben.D
#1Esben.D Member Administration Posts: 1,930  
posted: 6/19/2018 1:19:49 PM(UTC)
I'm in no way a Power BI expert, but you should be able to directly connect to the SQL Server database you are using for Lansweeper (if you are using an SQL server version).
DFullerton
#2DFullerton Member Posts: 1  
posted: 4/15/2019 7:08:27 PM(UTC)
Originally Posted by: mikerennie Go to Quoted Post
Has anyone been able to connect Lansweeper to PowerBI to generate dashboards and what not?

If so, how did you go about it?

Thanks!


Did you ever have any luck with this? Exploring the same thing myself...
sperigo
#3sperigo Member Posts: 4  
posted: 4/16/2019 8:28:19 PM(UTC)
Originally Posted by: DFullerton Go to Quoted Post
Originally Posted by: mikerennie Go to Quoted Post
Has anyone been able to connect Lansweeper to PowerBI to generate dashboards and what not?

If so, how did you go about it?

Thanks!


Did you ever have any luck with this? Exploring the same thing myself...



I've been able to do this. I got access to the backend database tables and then connect via PowerBI. I'm now beginning to create items from it. I used some of my current report tables and chose to show them in PowerBI. You simply need to know which (unless you want them all) tables to bring into your Power BI instance.
prabhu
#4prabhu Member Posts: 1  
posted: 10/15/2019 11:34:53 AM(UTC)
Originally Posted by: sperigo Go to Quoted Post
Originally Posted by: DFullerton Go to Quoted Post
Originally Posted by: mikerennie Go to Quoted Post
Has anyone been able to connect Lansweeper to PowerBI to generate dashboards and what not?

If so, how did you go about it?

Thanks!


Did you ever have any luck with this? Exploring the same thing myself...



I've been able to do this. I got access to the backend database tables and then connect via PowerBI. I'm now beginning to create items from it. I used some of my current report tables and chose to show them in PowerBI. You simply need to know which (unless you want them all) tables to bring into your Power BI instance.


So, how did you manage?
Hendrik.VE
#5Hendrik.VE Member Posts: 28  
posted: 10/15/2019 12:13:59 PM(UTC)
I have a couple of Lansweeper reports configured which I export on a weekly base to CSV files.
Based on these CSV files, I've then created Power BI reports in PBI Desktop which I published to PBI Service.
Using the Power BI On Premise Gateway, you can easily sync the Lansweeper CSV reports with PBI Service.

We use Power BI to monitor our "Security Posture", for instance how many Windows assets have installed the latest Windows updates, do they have AV and if yes is the AV signature still up to date, how many systems are (almost) end of life, vulnerability status, etc...
It's quite an 'eye opener' to have these reports in Power BI.

Another big advantage of Power BI is that you can manage roles, thereby making it possible that asset owners can only view their own assets in Power BI, and only the information I want them to see. So no need for me to give them access to Lansweeper, where they can view more then they're allowed to.
There's only a small monthly license fee for the Power BI Service license, which is required to view reports.

Of course it's also possible to directly query data from the LS SQL DB, but in my specific case that's not an option.

Active Discussions

Lansweeper Check if Netbios is disabled over TCP/IP
by  CyberCitizen   Go to last post Go to first unread
Last post: Today at 2:35:37 AM(UTC)
Lansweeper Change the Callto: link to Tel:
by  CyberCitizen  
Go to last post Go to first unread
Last post: Today at 2:05:38 AM(UTC)
Lansweeper Ticket Info Meter incorrect
by  pfalls  
Go to last post Go to first unread
Last post: Yesterday at 4:32:21 PM(UTC)
Lansweeper OS: Not latest Build of Windows 10 report
by  RKCar   Go to last post Go to first unread
Last post: Yesterday at 3:08:52 PM(UTC)
Lansweeper Windows Defender AV
by  Mikey!  
Go to last post Go to first unread
Last post: Yesterday at 2:48:54 PM(UTC)
Lansweeper Allow Users and cc Users to edit ticket form field
by  eoinpryan   Go to last post Go to first unread
Last post: Yesterday at 12:41:05 PM(UTC)
Lansweeper Mobile App
by  jdvuyk  
Go to last post Go to first unread
Last post: Yesterday at 2:28:56 AM(UTC)