Dynamic SQL Using Power Query

Posted on July 7, 2017July 11, 2017 by Philip Seamark

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

Posted on July 6, 2017July 6, 2017 by Freda Fung

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

Posted on July 6, 2017 by Reza Rad

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

Posted on July 5, 2017June 24, 2019 by Leila Etaati

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

Posted on July 4, 2017July 22, 2017 by Freda Fung

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

Posted on July 3, 2017June 21, 2019 by Leila Etaati

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[…]

Integrate Power BI into Your Application: Part 4 – Refresh Data Set

Posted on June 29, 2017 by Reza Rad

Power BI REST API is not just for embedding content or getting list of dashboards and reports. It also has many functions to work with data sets, gateways, and data sources. As one of the many exciting features of that; you can easily refresh a data set from an application. you can refresh it as Read more about Integrate Power BI into Your Application: Part 4 – Refresh Data Set[…]

Integrate Power BI into Your Application: Part 3 – Embed Content

Posted on June 28, 2017 by Reza Rad

In the part 1, you learned how to register an application to be able to interact with Power BI service and Azure environment. In the part 2, you learned how the authentication process works and how you can get the access token. In this part, I’m going to explain what is the process of embedding Read more about Integrate Power BI into Your Application: Part 3 – Embed Content[…]

Integrate Power BI into Your Application: Part 2 – Authenticate

Posted on June 27, 2017 by Reza Rad

In the part 1, you learned how to register an application to be able to interact with Power BI service and Azure environment. In this part, I’m going to explain what is the process involved after that in order to authenticate through your application into Azure Active Directory. This step is important step before doing Read more about Integrate Power BI into Your Application: Part 2 – Authenticate[…]