Azure, AI, SP, .NET, Microsoft - Knowledge Base

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...