Posts

Showing posts from October, 2018

Power BI Pivot Report - Rows value is in Column data

Image
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

PowerApps Notes – Part 1

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 other than