Renew the Cloud Hub Teams app permissions

Renew the Cloud Hub Teams app permissions

The Cloud Hub Teams app is a business application that provides data from your Microsoft 365 tenant, the Message Center and the Incident Center, as well as the status and history of global Azure services. Since Microsoft recently announced the discontinuation of the Microsoft Service Communications API, all organizations using the Cloud Hub Teams app have to renew their app permissions once in order to be able to use the successor API functions. See how it works here. ...

November 25, 2021 · 2 min · Toni Pohl
Ways to work with Power BI licenses

Ways to work with Power BI licenses

I recently wanted to share a Microsoft Power BI report with other users who only have the “Power BI (Free)” license. Well, with a “Power BI Pro” license, a report can be shared with other users. But I noticed that there are stumbling blocks when it comes to licensing. Here are my findings. First of all, I’m not a licensing expert (and don’t want to be one). However, I would like to ensure that as many users as possible can consume Power BI reports. With this goal in mind, I would like to share my experiences here. ...

September 27, 2021 · 6 min · Toni Pohl
Delegate365-Empty Reports

Delegate365-Empty Reports

In some tenants, sometimes reports appear blank. This can happen when reports are obfuscated in the Microsoft 365 admin center. See more here. Reports can be scheduled and downloaded in the Reports menu. When the report generation is completed, they show up in the list, as here. When the report is open and “no data available” is displayed (although you see users and groups in the Delegate365 pages)… ...

September 8, 2021 · 2 min · Toni Pohl
Delegate365 changelog 9.2.3-Add users to groups

Delegate365 changelog 9.2.3-Add users to groups

Delegate365 v9.2.3 brings a fix for the Message Trace function and offers a mechanism to add multiple users to one or more groups directly from the user list. See it here. Bulk add users to groups: In the users list, select more than one user. The menu on the right then shows the new option “Add users to group”. In this sample, 3 users are selected: Debra, Pradeep and Lee. The panel “Add users to group” opens and allows to select multiple groups of all types: Security groups, Distribution Groups, and Microsoft 365 Groups. The admin can search for the groups and add them to the Groups picker. By clicking on the Save button, a confirmation popup appears. When clicking Ok, the selected users will be added as members to these groups. A quick toast message shows the result in the bottom right corner. If the user already was a member of a group, this is ignored. ...

July 26, 2021 · 2 min · Toni Pohl
Message Trace in Delegate365

Message Trace in Delegate365

When you run a message trace operation to get status information about specific emails, the result can vary, depending on time zone settings. See a sample here. Show messages in the mail client In this sample, we work with an email sent from azure-noreply@microsoft.com. In Outlook we see the timestamp at Mon 7/5/2021 7:08 PM (2021-07-05 19:08). Message Trace in Delegate365 In Delegate365, admins can run a message trace to get information about the delivery status. When we run the message trace with the filter Startdate 2021-07-05 to Enddate 2021-07-05 - just this one day - and that user as recipient… ...

July 9, 2021 · 4 min · Toni Pohl
Power Platform Environments and Governance Tips

Power Platform Environments and Governance Tips

The Microsoft Power Platform enables individual solutions to be developed and business processes to be easily automated. When it comes to controlling the solutions, it is important to establish an IT governance in the organization. There are many areas and details about it. For this reason, I’ve put together a summary here with some news and helpful tips. The Microsoft Power Platform includes Power BI, Power Apps, Power Automate, and Power Virtual agents, leveraging the common infrastructure of the Microsoft Dataverse (the former Common Data Service) and Data Connectors. Dynamics 365 and the Power Platform are both deeply coupled with Dataverse and are held in containers called environments. A governance strategy usually starts with organizing the environments accordingly. Environments allow to separate Production, Test and Development. See more at Environments overview and at Microsoft Power Platform guidance documentation. ...

July 5, 2021 · 5 min · Toni Pohl
Delegate365 changelog 9.2.2-Manage group owners

Delegate365 changelog 9.2.2-Manage group owners

Delegate365 v9.2.2 allows to manage group owners. The permission policies have been extended and the current admin can add him- or herself or additional group owners for Security Groups and Microsoft 365 Groups. See a description of the latest features here. Enable (or disable) the manage owner feature: To enable the “manage owner” feature, you have to set the corresponding permission policies in the Groups - Security Groups - Manage owner from No to Yes, as here. Then, click on the Save button at the page end of the permission panel. By default, this new setting is disabled. So, don´t forget to switch it on, if your admins shall be able to set the group owner for security groups (in the same way as for Microsoft 365 Groups). Once the setting is set, it will be effective for all admins that have that permission policy assigned. To learn more about setting permission policies, see here. ...

June 16, 2021 · 4 min · Toni Pohl
Delegate365 changelog 9.2-PowerShell module update

Delegate365 changelog 9.2-PowerShell module update

The Delegate365 PowerShell module got a small update to expand a user´s assigned licenses, license plans and proxy addresses. See the following description. See the description at https://github.com/delegate365/PowerShell how to use the Delegate365 PowerShell module- Check the Delegate365 PowerShell module version First, ensure you have the latest version of the Delegate365 PowerShell module installed. Check with Get-Module as here. The version must be 1.0.0.10 (or in future a higher version). ...

June 11, 2021 · 2 min · Toni Pohl
Optimize SQL queries using subqueries for lookups in Azure SQL Databases

Optimize SQL queries using subqueries for lookups in Azure SQL Databases

I like to work with Azure SQL Databases and use data from the cloud without any administrative effort. When working with apps, App Insights helps to detect anomalies, and to analyze bottle necks. Although SQL Azure can scale very well, we discovered performance issues in some legacy apps. Read here how we solved that by optimizing TSQL data queries. The scenario There is an older web application here that is connected to an SQL database that is running in an SQL elastic pool. App Insights showed the reason (the SQL queries) for the bad performance. Diving deeper, the elastic pool and the database / Query Performance showed performance issues in detail with certain queries which had very long runtimes. As we see in the following screenshot, there are two long running queries. Query 164 has been executed almost 274,000 times in the past 24 hours, consuming more than 6:40 hours. We started to investigate this issue. ...

April 27, 2021 · 5 min · Toni Pohl
Join us at globalazure.at 2021

Join us at globalazure.at 2021

We look forward to participating in the Global Azure Austria event again! The event is part of the event series Global Azure 2021. As in the past years, the Austrian edition of Global Azure 2021 is provided by the Coding Club Linz. Like last year, Global Azure 2021 will be a virtual event again and deliver over 30 sessions to your home on April 16th. Join us! Global Azure is organized by the Azure community for the community. The annual series of events offers meetings and exchanges over 3 days. The Azure communities around the world are organizing localized live streams for everyone around the world to join and learn about Azure from the best-in-class community leaders. ...

April 15, 2021 · 2 min · Toni Pohl