The POWER of Microsoft Lists and Power BI — Daniel Glenn
My second visit with Adam at Guy in a Cube highlights the benefits of using data from a Microsoft List in Power BI. Many organizations have data in their SharePoint and Microsoft Lists. I show how you can visualize that data using Power BI — in more than one way! Microsoft Lists and Power BI: collaboration power!
In this video we talked about how you can use the Power BI integration feature in lists to visualize them. Power BI will use AI to create a report that you can then save right back to the list. Then others that access the list can use the report!
Adam pointed out that the list in my demonstration was using some fancy formatting, so I of course gave a shoutout to my friend and fellow Microsoft MVP Chris Kent.
I then showed a recently announced feature which allows you to bring a Microsoft List in as a dataset in Power BI from the list itself. Amazing!
Check out the video below and let me know your thoughts.
Bonjour à tous, C’est un plaisir pour moi d’écrire cet article autour de la mise à profit des fonctionnalités prêtes à l’emploi de SharePoint Online pour Construire des expériences adaptées …
The formal date for general availability for Stream on SharePoint was October 12, 2022.. According to Microsoft 365 notification MC496849 (12 Jan 2023), Microsoft will retire the original (classic) version of the Stream video app on February 15, 2024. After making the migration tool to move videos to Stream for SharePoint available last October and continuing to roll out features to make Stream on SharePoint functionally equivalent, Microsoft considers that it’s appropriate to start the shutdown clock.
Users won’t be able to upload new content to Stream classic after May 15, 2023, and will lose access to the Stream classic app after October 15, 2023. Microsoft plans to release an update to allow organizations to adjust these dates through the Stream admin center sometime in February. However, nothing will stop the final shutdown happening in February 2024. At that point, Microsoft will block access to Stream classic for everyone and remove any video content that tenants fail to migrate. For more information about Stream migration and the retirement timeline, see this article.
Interestingly, Stream users in all tenants will see a button to allow them to upload videos to Stream on SharePoint from January 18, 2023. This is a small hint to end users that Stream for SharePoint is the future.
Stream Live Events
Stream live events are an exception to the retirement strategy. I’m unsure if this aspect of Streams classic ever got much traction but no doubt some tenants use the functionality. Microsoft is pointing people to Teams live events with external encoder support as the replacement. Microsoft says that they will announce a retirement date for Stream live events sometime in the first quarter of 2023 and allow tenants six months to prepare before terminating the service.
Stream on SharePoint More of a Service than an App
As I have noted before, Stream on SharePoint is fundamentally different to Stream classic. The original Stream followed the template laid down by the Office 365 Video app. Stream classic created the same kind of portal powered by Azure media services and Azure blob storage. Apart from the obvious storage relocation, Stream on SharePoint is much more about delivering video services throughout Microsoft 365 than being a standalone video management app. Deep connections with SharePoint Online, OneDrive for Business, Viva Connections, Yammer, and Teams mark the new Stream approach to making its services for video capture, storage, and replay available throughout Microsoft 365. The new Stream video player (Figure 1) is an example – it’s called to play videos throughout Microsoft 365.
Figure 1: The Stream on SharePoint video player
Video is a steadily increasing presence within Microsoft 365. Recent examples include the introduction of video messages (1 minute maximum) in Teams chat and video stories (3 minutes maximum) in the Yammer storyline. Yammer stores its video in user OneDrive for Business accounts, but Teams video chats are not captured in SharePoint (yet). Eventually, I anticipate that all video content created by Microsoft 365 users will be in SharePoint storage. It just makes sense.
Where’s Clipchamp?
The position of Clipchamp in Microsoft 365 is still not as obvious as people perhaps expected it to be following Microsoft’s acquisition of the company in September 2021. Stream includes basic video recording and effects functionality without the sophisticated editing capabilities available in Clipchamp, which proclaims itself to be “the new video editor from Microsoft 365” (personal). However, there’s still no sign of a Clipchamp service plan in any of the Office 365 SKUs.
On to Stream 2.0
Migrations can be painful projects. In the case of Stream classic, the migration tools do a fair job and the overall process appears to be working well. Some might complain about minor losses in functionality (like videos no longer being owned by Microsoft 365 groups), but overall this migration is not difficult. Video is becoming pervasive across Microsoft 365. All we need now is a nice video editor to make everyone as good as they can possibly look.
So much change, all the time. It’s a challenge to stay abreast of all the updates Microsoft makes across Office 365. Subscribe to the Office 365 for IT Pros eBook to receive monthly insights into what happens, why it happens, and what new features and capabilities mean for your tenant.
Thanks to the workflow that notifies me of updates to the Microsoft Graph API, I saw a new addition to the list: the sitePage resource type.
This is exciting for me, as I currently have some workflows that distribute SharePoint pages to various sites both within our own tenant, as well as client tenants. Currently these are triggered by a page being published in a central location, with specific information used as trigger conditions.
What’s annoying about this scenario is that I need to create connectors in Power Automate to the client tenant using an account in their environment. It also means I need a workflow per client (to keep it clean).
Now with the addition of the sitePage resource type in Microsoft Graph, I can make this work programmatically across any number of clients — all from a single workflow.
WARNING: This is a beta feature at present, so don’t use it for production systems unless you’re find to accept the risks.
Requirements
The requirements of this are fairly simple. We need:
An app registration in Azure AD that has the “Sites.ReadWrite.All” application permission added
A repository where the details are stored, including:
Client name
Tenant ID
App/Client ID
Secret
SharePoint site ID
Now, we could use a different way to authenticate, and we could also use an action to perform a search in the tenant to find the relevant site by name or URL, but if we’ve got that — then it’s not exactly difficult to get the SharePoint site ID and store it in our repository.
For the purposes of this, I’m going to store it in a SharePoint list:
Workflow
At a high-level, my workflow is quite simple:
In my specific scenario, all the workflow is doing is publishing a page with an embedded video, as part of a program of regular content I create for clients. So all I need to provide is a page title and the URL suffix from the embed code.
The next step of the workflow takes my page title, and turns it into a file name:
From here, we’re now ready to retrieve all the sites we want to apply this to:
Within our Apply to Each, we have three steps:
Create the page
Parse the JSON of the page creation
Publish the page, using the ID from step 2
(If you’re comfortable with extracting the page ID value directly from the results of step 1, then you don’t need the Parse JSON action.)
In the page creation action, I’m creating a very simple page that only has a single embed web part on it, and I’m passing variables from both the trigger as well as the Get Items action.
The Parse JSON is relatively straightforward:
And for the final step we hit publish on the page:
And that’s it! We have a simple page published in each tenant listed, with the same content.
If you want something more glamorous, refer to the sitePage resource type page to get a breakdown of the structure of the body of the content.
Appendix
Here’s the full details of the body of the page creation and Parse JSON actions.
OneDrive/SharePoint Share Control — Simplifying Link Settings
Creating sharing links is going to be clear and simple thanks to some changes in the Share Control window for OneDrive and SharePoint. Descriptions are simpler. See who is using a sharing link at a glance. This should simplify choosing the right type of link for sharing.
— OneDrive/SharePoint Share Control — Simplifying Link Settings — MC467240 — More Layout Options and Yammer Card Content for the Feed Web Part for Viva Connections — MC467626 — Editor Using Context IQ: Inline Search Within Documents in Word for the Web — MC467908 — Authenticator number matching to be enabled for all Microsoft Authenticator users — MC468492
Join Daniel Glenn and Darrell as a Service Webster as they cover the latest messages in the Microsoft 365 Message Center.
See recommended Power BI content. Receive signals such as “Megan edited your Power BI report”. Isaac created a new report in your team workspace. Power BI with more power to reach you where you are working, across Microsoft 365.
— ContextIQ: Inline Search During Message Composing — MC462919 — SharePoint Tenant URL Rename — General Availability — MC462923 — Office for the web rebrand on Service health and Message center — MC465552 — Microsoft Teams: Users ability to delete chats — MC466199 — Announcing Public Preview of Power BI and Microsoft Graph Integration — MC466200 — Relevance recommendation for Message center posts — MC466202
Join Daniel Glenn and Darrell as a Service Webster as they cover the latest messages in the Microsoft 365 Message Center.
The Teams meeting video gallery shows active speakers. Now you will be able to page the gallery to see more people with their camera on. Check to see if Serena is still in the meeting. Check if your camera-on audience is still engaged. What else does this week have in store in the Message Center?
— Microsoft Teams Paging on Video Gallery — MC455894 — Advanced Virtual Appointments in Teams Premium — MC454804 — Delete or rename files in a channel and in your OneDrive folder in Teams — MC455193 — Planner’s task assignment e-mail notification design update — MC455515 — SharePoint admin center: Streamlining management of site information across Microsoft Teams and Microsoft 365 Groups — MC455520
Join Daniel Glenn and Darrell as a Service Webster as they cover the latest messages in the Microsoft 365 Message Center.
Connexion
