Azure, .NET, SharePoint/Office 365, Power Platform, ADF - Knowledge Base

Productivity – The word surrounding with us in all times. How productive we are? How did we plan and able to execute our task? What level of smart decisions we able to take in our daily work? In daily basis, we get involved by going through more than hundreds of emails and we need to reply many of them, engaged with meetings, working with document collaborations, doing virtual meetings etc. Sometimes people overloaded with emails, and it is obvious for human being to literally go through each of the email content within your busy schedules. Sometimes exhausted with meetings, back to back from morning till late afternoon. Due to all sort of similar activities, we can assume, people participation in the meeting were ineffective. We unable to contribute our 100% there, sometimes meetings are so boring and usually ineffective. So, how can we fix all these inefficiencies and boost up ourselves to drive in a smart way. To do so, we should know where our efforts gets voided and where we...

This post is for all PB lovers. I tried to place some useful links which you may need to prepare and present reports in you dashboard. Hope below link will help you here. Schedule Refresh Dashboards don't refresh automatically - https://community.powerbi.com/t5/Service/Dashboards-don-t-refresh-automatically/m-p/91990/highlight/true#M15836 How to set your browser to refresh automatically -  https://www.online-tech-tips.com/computer-tips/automatically-refresh-web-pages-in-browser/ Data refresh in Power BI: https://docs.microsoft.com/en-us/power-bi/refresh-data What is Power BI gateway : https://docs.microsoft.com/en-us/power-bi/service-gateway-getting-started Manage your data source - Oracle (add enterprise gateway) : https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-manage-oracle Connect with SP List: Take the SP Site url and choose the Get data >> Web or " online SharePoint list " ( under Online service ).  Check within the e...

Design decision is very important while working on Cloud. Which platform you are going to choose, or based on your organization roadmap how you are going to setup your platform. All these decisions are critical for a successful story. Decisions are taken based on the requirement you have and based on the metrics hosting provider can provide. Let's make it simple way on how to start and then pursue. Organization willing to go for Cloud for mainly several reasons. One of the important reason it saves a lot of cost to them.  The main objective is to store their data, let their application run just like it is running on their premise and ensure data security. So, let's break it in following simple blocks. Infrastructure/Data storage Security Performance Governance & Monitoring Value Added Service Let's explore our first point  -  Infrastructure/Data storage . What does it make sense to us? What exactly it can provides. And then we need to find out w...

This is final part 3 of Azure Storage Service. We talked about it in earlier articles  Part 1 and Part 2 . Azure Storage API Azure Storage provides a REST API to work with the containers and data stored in each account. There are independent APIs available to work with each type of data you can store. ·          Blobs  for unstructured data such as binary and text files. ·          Queues  for persistent messaging. ·          Tables  for structured storage of key/values. ·          Files  for traditional SMB file shares. Storage REST APIs are accessible from anywhere on the Internet, by any application that can send an HTTP/HTTPS request and receive an HTTP/HTTPS response. For example (HTTP) GET https://[url-for-service-account]/?comp=list&include=metadata – This returns t...

This is continuing part of Azure Storage. We talked about part 1 article on this and this is second part of it. Storage Account Settings Following three settings that apply to the account itself Name Deployment model Account kind Name : must be globally unique within Azure, use only lowercase letters and digits and be between 3 and 24 characters Deployment model : It is the system Azure uses to organize your resources. The model defines the API that we use to create, configure, and manage those resources. Azure provides two deployment models. ·          Resource Manager: the current model that uses the Azure Resource Manager API ·          Classic: a legacy offering that uses the Azure Service Management API Microsoft recommends that you use Resource Manager for all new resources. Account kind : Storage account kind is a set of policies that determine which data...

I n this article and subsequent a few articles, will talk about some important objects of Azure Storage Service and it's utility. This is actually kind of learning hand book. Azure Storage Services Microsoft Azure Storage is a managed service that provides durable, secure, and salable storage in the cloud. A single Azure subscription can host up to 200 storage accounts, each of which can hold 500 TB of data. If you have a business case, you can talk to the Azure Storage team and get approval for up to 250 storage accounts in a subscription, which pushes your max storage up to 125 Petabytes! Azure data services:  Azure storage includes four types of data: Blobs: A massively scalable object store for text and binary data. Files: Managed file shares for cloud or on-premises deployments. Queues: A messaging store for reliable messaging between application components. Tables: A NoSQL store for schemaless storage of structured   Blob storage : Is ...

In earlier post , we have gone through some insights of. Continuing with that, below is another important point on how PowerApps provides internal column names. For SharePoint and Excel data sources that contain column names with spaces, PowerApps will replace the spaces with " _x0020_ ". For example, " Column Name " in SharePoint or Excel will appear as " Column_x0020_Name " in PowerApps when displayed in the data layout or used in a formula. In this post, we’ll discuss on model driven apps. Let’s start. Model Driven Apps Model-driven app design is an approach that focuses on adding dashboards, forms, views, and charts to your apps. With no code, or very little, you can build apps that are simple or very complex. In canvas apps, the designer has total control over the app layout. In model-driven apps, on the other hand, much of the layout is determined by the components you add. The emphasis is more on quickly viewing your business data ...

This post is for Information Right Management in O365/SharePoint. It is self explanatory based on the images. We' have two major areas - a) Site Collection level, b) Site Content level. Here the url to set Retention Policy in Site Collection level - https://<<SPO Site Collection URL>>/_layouts/15/policylist.aspx Below the steps - how you can set Retention Policy in Content Type level This is pretty simple. Only thing is you play around the configuration and set the rule there. Hope this will helps you!

Power BI provides a wonderful platform to generate complex reports. Today, I'm going to walk through one such example. I have master and child tables and what I want to draw is - one of the column's data in master table will have row entry, and associated child tables row data will be display in column. In excel, this is called pivot table. So, bring a pivot table of UI in Power BI. Below the example data. I have one master table entry where different object names are exist in individual row. Also, child table contains sub-objects based on the master table object name. Now, what I want is, all objects will be displayed (here Car, Rail, Aeroplane) will be displayed in row wise, and their's associated sub-objects will be displayed in columns wise and contains field value of other sub-object. How we'll achieve this? First thing is load the data in Power BI desktop and then create the master- child relationship. Now, if you go the the report pan, you will fin...

Now, we are era of Power family – PowerApps , SharePoint , Power BI . And, I tagged it as P3  This is a great combination framework to develop business apps in scalable format. Obviously, We have support of another great technology seed – Microsoft Flow.  Mind-blowing workflow integration in easy step-by-step manner. Thank You Microsoft! This post mainly focuses on PowerApps, and I choose this as first place because it is new and getting some insight of it will help others as well. People who already work on this technology and facing issues or who just started working on it, will be most benefited. It is very simple (simpler than InfoPath) and easy to learn. Going through some key points on different PowerApps development areas here. Data Sources Data Sources are external information stored in cloud In and most canvas apps use external information. The most common data sources are tables and list hosted on O365 or on-premise SharePoint environment. Data sources o...

New feature: Insight Services in Excel (Win32): MC147874 Insight Services in Excel is a new Office 365 feature that helps organizations make better use of their data. This feature is already available for English language customers in the Office Insider program, and we will be rolling this out for additional languages starting October 1. How does this affect me? Insight Services in Excel analyzes data and its structure and automatically generates a series of recommendations and useful ways to make sense of the data, including high-level summaries, statistically significant findings, and recommended visualizations. If you are an English language customer and a part of the Office Insider program, this feature is already available to you. On October 1, we will begin rolling this feature out to Office 365 organizations outside of the Targeted Release program as well as organizations in other regions, starting with the French, German, Spanish, Chinese and Japanese markets. Insig...

Document ID , a SharePoint service provides unique ID to individual document in library. You can activate this service by enabling site collection feature - Document ID settings. Document Set is used for content organizer. This is being used to set/tagged a group of  related documents in the library. Like, all documents related with LAW or HR or Product 24.5. This has been earlier SharePoint 2010 and it is a kind content type. This is site collection feature and you can find it as Document Sets . What is doces internally is created a folder (based on the document tag) and keep the related documents there. If you use both the Document Set and Document ID , then every Document Set also having an unique ID (as these are related folders resides under library) same as individual document do have. During migration, sometimes DocumentID not migrated properly by different major migration tools. Could be because Document Set not migrated properly and related documents (under that D...