In this blogpost we will take a look at how to automate the process of updating the data in the Power BI report we created in part 2, without any need of a computer/server. We will manage to do this by scheduling a Runbook in Azure Automation. I asume that you allready have signed up … Continue reading Integrating PowerShell with PowerBI: Automating in Azure (Part 3)
So now if you read part one, you are set to go starting using this newly created integration. (If not read part one here.) What we will take a look at in this post: - What you can do with the module. - Writing a reporting script that send data to Power BI. - Create … Continue reading Integrating PowerShell with PowerBI: Module, script and reporting (Part 2)
Power BI is a extremely powerful data and visualization tool. It have opened a new world for me. But the first thing i always think about when taking a look at Microsoft products, there have to be a way to control this with PowerShell. I did not find any good information about any PowerShell module … Continue reading Integrating PowerShell with PowerBI (Part 1)
I see on Tech Community there have been some requests regarding the call que timeout in Skype Online. The minimum time you can set is 60 seconds, before the call is passed on to somewhere else. I have seen some requests that people need/want to set the timeout to less than 60 seconds. In the … Continue reading Call que timeout, less than a minute?
Short script that gets all the users in your Office 365 tenant, and finds the password age. Creates a list with UPN and password age, then sort by oldest password. Also finds the average password age for your tenant.
Wrote a short script that list all SharePoint sites in your Office 365 tennant with the LastItemUserModifiedDate. Could be handy to see if some sites are not used anymore. First i used Get-SPOSite and LastContentModified, but after some research it turned out that it was not so reliable: https://social.msdn.microsoft.com/Forums/office/en-US/6e264b4e-e4b4-4b46-a7b0-9686c0f6128e/lastcontentmodifieddate-is-not-giving-me-the-right-values-for-site-collections-sharepoint-online?forum=sharepointdevelopment My script is a modified version … Continue reading SharePoint LastItemUserModifiedDate
Script for listing all groups with owners and members in Office 365. Added count of groups left to process to see progress when running scripts in large environments. Run either: Get-UnifiedGroup | Get-Member or Get-UnifiedGroupLinks | Get-Member to see what other properties you get add to the report. The script creates one CSV file for … Continue reading Office 365 Groups reporting