Basics of M: Power Query Formula Language

M is the powerful language behind the scene of Power Query. Any transformation you apply will be written in M language. For many, M looks like a scary language. In this post I like to explain a bit of basics of M. Not mentioning any functions. Mainly I want to explain to you how the Read more about Basics of M: Power Query Formula Language[…]

Interactive Charts using R and Power BI: Create Custom Visual Part 3

In the last two posts (Part 1 and 2), I have explained the main process of creating the R custom Visual Packages in Power BI. there are some parts that still need improvement which I will do in next posts. In this post, I am going to show different R charts that can be used Read more about Interactive Charts using R and Power BI: Create Custom Visual Part 3[…]

PowerApps – Building Timesheet App without Coding – Part 3 – Connecting to multiple data source, and getting ready to build dropdown lists

We have got an idea of PowerApps working environment from the last post, now we can start customising functionalities of our TimeSheet App. Click here for a recap on all functions for our TimeSheet App. We are working on our first function in this post – Dropdown list: When creating a new timesheet record, team Read more about PowerApps – Building Timesheet App without Coding – Part 3 – Connecting to multiple data source, and getting ready to build dropdown lists[…]

Dynamic SQL Using Power Query

Every so often I find myself needing to import data, but only want data relevant to values already existing in my data model.  This is common where I build smaller models based on a subset of fact or transaction records.  Rather than bring in entire dimension tables, I may only need the dimension records that Read more about Dynamic SQL Using Power Query[…]

PowerApps – Building Timesheet App without Coding – Part 2 – Get to know the environment

The last post, we introduced Microsoft PowerApps, the solution to connect, create and share business apps with your team without coding, hence boost efficiency in your organisation, facilitate lean delivery and improve business agility. Pickup from the TimeSheet App we generated in just a minute from the last post, this time, we will help you Read more about PowerApps – Building Timesheet App without Coding – Part 2 – Get to know the environment[…]

Integrate Power BI into Your Application: Part 5 – Data Source Management

New REST API of Power BI is revolutionary. In addition to embedding content in Power BI, ability to refresh data set from API, it also gives you many functions to work with Gateways and Data Sources. With this API, you can set up new data sources, clone data sets, check the credentials of a data Read more about Integrate Power BI into Your Application: Part 5 – Data Source Management[…]

Interactive Charts using R and Power BI: Create Custom Visual Part 2

In the last posts, I have explained the main process of creating R custom visuals. In this post I am going to show how to: 1- Have more custom visuals 2- Different charts that we can have in Power BI 3- Explain some issues Have more custom visuals to have more R visuals, it is Read more about Interactive Charts using R and Power BI: Create Custom Visual Part 2[…]

PowerApps – Building Timesheet App without Coding – Part 1

There may be times that you or your team members are spending a lot of time managing tedious administration tasks and company data.  Chances are you may have thought of how documentation automation will boost efficiency in your organisation, facilitate lean delivery and improve business agility.  However, you do not know coding or you do Read more about PowerApps – Building Timesheet App without Coding – Part 1[…]

Interactive Charts using R and Power BI: Create Custom Visual Part 1

I am so excited about using Plotly packages in Power BI. So What is Plotly: is an R package for creating interactive web-based graphs via the open source JavaScript graphing library: https://plot.ly/r/getting-started/ this feature has been added recently and had been announce by Christian Christian Berg in Data insight summit 2017. I started to search about Read more about Interactive Charts using R and Power BI: Create Custom Visual Part 1[…]