Pankaj Surti's Blog

Role Based Access Control
https://aka.ms/teams-rbac

Teams settings
https://aka.ms/teams-settings

Messaging policies
https://aka.ms/teams-messaging

Meeting settings
https://aka.ms/teams-meeting-settings

Meeting policies
https://aka.ms/teams-meeting-policies

Live events policies
https://aka.ms/teams-live-events

External access
https://aka.ms/teams-external-access

Guest access
https://aka.ms/guests-o365-groups

Ability to create teams
https://aka.ms/create-o365-groups

Classification for teams
https://aka.ms/teams-classification

Retention policies
https://aka.ms/teams-retention

Expiration policies
https://aka.ms/teams-expiration

PowerShell for Teams
https://aka.ms/teams-powershell

Graph API for Teams
https://aka.ms/teams-graph

I have created a Postman collection to Access SPO using REST API.

https://github.com/pankajsurti/Access-SharePoint-Online-using-Postman

More details are here

http://www.ktskumar.com/2017/01/access-sharepoint-online-using-postman/

My customer has a need to provide download links for underlying data of Power BI Embedded report. The embedding worked is all worked fine on the public site page. We also provided the download links to download underlying data in CSV and JSON format. All worked fine but the download links did not work in IE11. After searching on web found this article which was so helpful and worked with no issues.

Download JSON data in CSV format Cross Browser Support -> https://ciphertrick.com/download-json-data-in-csv-format-cross-browser-support/

I will not repeat what is discussed in the above blog. However my need was to support JSON format file download as well. So I used the following code as shown in the blog.

IEwindow.document.execCommand(‘SaveAs’, true, fileName + “.json”);

The issue is that the file type .json was not liked by IE so it never saved this file. I am guessing something to do with the code as a JSON file. To save you the trouble please DO NOT use .json instead use something like this.

IEwindow.document.execCommand(‘SaveAs’, true, fileName + “.json.TXT“);

That line was OK for IE and it worked like a charm. I hope it is helpful to you.

My customer had a requirement to download the Summary data of the report visual for Power BI embedded report.

I went to achieve this as a wrong path first. I hope you don’t do the same mistake.

The path I first took was to use the REST API below.
Datasets – Get Dataset -> https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getdataset

Push Datasets – Datasets GetTables -> https://docs.microsoft.com/en-us/rest/api/power-bi/pushdatasets/datasets_gettables

DO NOT use those APIs to get the dataset of an existing report. This will not work. These APIs only work for the data you pushed via API. The data set will show the API ACCESS as shown below.

To download embedded report data use the Power BI client JS api to download.

Export Data-> https://github.com/microsoft/PowerBI-JavaScript/wiki/Export-Data

The call is made using the MS Graph API call.

https://docs.microsoft.com/en-us/graph/api/group-list-owners?view=graph-rest-1.0&tabs=http

Q:How does the MS Graph API work?

A: The following are the steps.

1. Register an Azure AD app with the following API permission granted and consented.

Microsoft Graph (2)
     - Group.Read.All
     - User.Read.All

2. Using the REST API to get the Access Token.

POST https://login.microsoftonline.com/<<<Guid for tenant>>>/oauth2/v2.0/token

REQUEST BODY:

grant_type=client_credentials&client_id=<<Azure AD App ID>>&client_secret=<<<the secret>>> &scope=https%3A%2F%2Fgraph.microsoft.com%2F.default

RESPONSE BODY:

{

“token_type”: “Bearer”,

“expires_in”: 3599,

“ext_expires_in”: 3599,

“access_token”: “<<blah blah long string>>”

}

1. Using the above access token make a call to get the owners.

GET https://graph.microsoft.com/v1.0/groups/<<GuidforGroup>>/owners

It will give the data response as the following.

{

"@odata.context": "https://graph.microsoft.com/v1.0/$metadata#directoryObjects",
"value": [
{
"@odata.type": "#microsoft.graph.user",
"id": "12d7bb75-763b-4103-a367-e6fa9ca0edaa",
"businessPhones": [
   "8005555555"
],
"displayName": "MOD Administrator",
"givenName": "MOD",
"jobTitle": null,
"mail": "admin@TenantName.OnMicrosoft.com",
"mobilePhone": "555-555-5555",
"officeLocation": null,
"preferredLanguage": "en-US",
"surname": "Administrator",
"userPrincipalName": "admin@TanantName.onmicrosoft.com"
}
]
}

Q: How to make such calls from Power Automate?

A: Here is the answer in the link below.

https://www.infopulse.com/blog/using-microsoft-graph-api-inside-microsoft-flow-office-365/

I have been working on the Microsoft Security Graph API to get the reports.
I have created a PostMan collection put it on the GitHub Repo.

https://github.com/pankajsurti/MicrosoftGraphSecurityAPIPostMan 

I have found following articles very useful.

https://aka.ms/GraphSecurityDocs

https://aka.ms/GraphSecurityAPICode

https://aka.ms/GraphSecuritySolutionsConnectors

https://aka.ms/GraphSecurityWhitePaperSevenWays

https://aka.ms/GraphSecurityQuickStarts

https://aka.ms/GraphSecuritySDK

https://aka.ms/GraphSecurityConnectorsBlogPost

https://aka.ms/GraphSecurityPowerBIConnectorBlogPost

https://aka.ms/GraphSecurityPowerShellModulePost

https://aka.ms/GraphSecurityCuratedQueries

https://aka.ms/GraphSecurityJupyterNotebooks

https://github.com/Microsoft/MicrosoftGraphSecurity

Five cool security apps you can build using Microsoft Graph | BRK3073
https://www.youtube.com/watch?v=Klc9z7jbQio

I wrote this sample console program to read Excel file and bulk load to the SQL.

It uses the ExcelDataReader NuGet package. The source is located on GitHub. Enjoy!

https://github.com/pankajsurti/BulkLoadExcelData2SQL

I have created Postman collection for the Office 365 Usage Reports. Enjoy!

https://github.com/pankajsurti/O365UsageReportsAPIs

Office 365 Usage Reports – https://docs.microsoft.com/en-us/graph/api/resources/report?view=graph-rest-1.0

Office 365 Usage Analytics Adaption Package is located below.

https://docs.microsoft.com/en-us/office365/admin/usage-analytics/usage-analytics?view=o365-worldwide

Microsoft 365 usage analytics data model

https://docs.microsoft.com/en-us/office365/admin/usage-analytics/usage-analytics-data-model?view=o365-worldwide

https://docs.botframework.com 

Virtual Assistant Overview

*** Useful YouTube Learning links ***
A deep-dive into conversational AI using Azure Bot Service and Cognitive Services | BRK4001
https://www.youtube.com/watch?v=j2-FWeIqYOg
Building enterprise ready scalable AI solutions using Azure Cognitive Services | BRK3029
https://www.youtube.com/watch?v=630F60EfPcQ
Learn to configure a virtual agent with Power Virtual Agent in minutes not days | BRK2372
https://www.youtube.com/watch?v=WEFtQ6rIK8U
Advanced Natural Language Understanding (NLU) models using LUIS and Azure Cognitive | BRK2188
https://www.youtube.com/watch?v=JdJEV2jV0_Y
Create sophisticated enterprise-ready bots from your existing data with no code | THR2136
https://www.youtube.com/watch?v=5xZ1_J4qfMk
Creating enterprise conversational user experiences with virtual assistants | THR2018
https://www.youtube.com/watch?v=C38fRHQz9po
Three ways to build bots with Azure AI that can make you a hero in your organization | THR2147
https://www.youtube.com/watch?v=Pcv0v6KKoiQ
Let’s build a knowledgeable chatbot with Microsoft Bot Framework Azure Bot Services | BRK1037
https://www.youtube.com/watch?v=x0hxnnD8Nyo
Microsoft Power Virtual Agents integration with Azure Bot Framework Skills
https://www.youtube.com/watch?v=cU7_cmMPW34
*** You Tube Learning links ***