
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-15-2018 04:52 PM
Has anyone been able to connect Lansweeper to PowerBI to generate dashboards and what not?
If so, how did you go about it?
Thanks!
If so, how did you go about it?
Thanks!
Labels:
- Labels:
-
General Discussion
5 REPLIES 5

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-15-2019 01:13 PM
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.
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.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-15-2019 08:08 PM
mikerennie wrote:
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...

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-16-2019 09:28 PM
DFullerton wrote:mikerennie wrote:
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.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-15-2019 12:34 PM
sperigo wrote:DFullerton wrote:mikerennie wrote:
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?

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-19-2018 02:19 PM
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).
