Author Archives: Pankaj

Unknown's avatar

About Pankaj

I am a Developer and my linked profile is https://www.linkedin.com/in/pankajsurti/

Governance, management and lifecycle in Microsoft Teams

Role Based Access Controlhttps://aka.ms/teams-rbac Teams settingshttps://aka.ms/teams-settings Messaging policieshttps://aka.ms/teams-messaging Meeting settingshttps://aka.ms/teams-meeting-settings Meeting policieshttps://aka.ms/teams-meeting-policies Live events policieshttps://aka.ms/teams-live-events External accesshttps://aka.ms/teams-external-access Guest accesshttps://aka.ms/guests-o365-groups Ability to create teamshttps://aka.ms/create-o365-groups Classification for teamshttps://aka.ms/teams-classification Retention policieshttps://aka.ms/teams-retention Expiration policieshttps://aka.ms/teams-expiration PowerShell for Teamshttps://aka.ms/teams-powershell Graph API for Teamshttps://aka.ms/teams-graph

Posted in Uncategorized | Leave a comment

Build 2020 Videos

SK100 Building modern enterprise-grade collaboration solutions with Microsoft Teams SK101 Transform everyday business processes with Microsoft 365 platform integrations SK102 What’s new with Microsoft Teams as a platform SK106 Tips for Teams developers: Authentication and proactive messaging SK107 Developing with … Continue reading

Posted in Build2020, Uncategorized | Leave a comment

REST API for SPO using Postman

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/ Refer https://bloggerbrij.blogspot.com/ Refer https://docs.microsoft.com/en-us/sharepoint/dev/general-development/role-inheritance-elevation-of-privilege-and-password-changes-in-sharepoint?redirectedfrom=MSDN Understanding SharePoint’s REST and Search API Part 1 – Selecting Items http://michaelsoriano.com/understanding-sharepoint-rest-api-part-1-selecting-items/ (SHAREPOINT REST WALL PAPER) https://www.microsoft.com/en-us/download/details.aspx?id=41147

Posted in Uncategorized | Leave a comment

Download JSON data Cross Browser Support specially IE

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 … Continue reading

Posted in Uncategorized | Leave a comment

Download Power BI visual data as CSV or JSON

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 … Continue reading

Posted in Uncategorized | Leave a comment

Getting Group owners using MS Graph API in Power Automate

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. Register an Azure AD app with the following API permission granted and consented. Microsoft Graph (2) … Continue reading

Posted in Uncategorized | Leave a comment

Microsoft Graph Security API

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/GraphSecuritySDKContinue reading

Posted in Uncategorized | Leave a comment

Bulk Load Excel file to the SQL

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  

Posted in Uncategorized | Leave a comment

Office 365 Usage Reports Postman Collection

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

Posted in Uncategorized | Leave a comment

Microsoft Virtual Assitant

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 … Continue reading

Posted in Uncategorized | Leave a comment