Using Merge in Power Query gives you the ability to join on a EQUAL join with one or more fields between two tables. However, in some situations you need to do the Merge Join not based on equality of values, based on other comparison options. One of the very common use cases is to Merge Read more about Dates Between Merge Join in Power Query[…]
At the time of writing this post; there are already more than 97 custom visuals posted in Office Store. The list includes many interesting custom visuals. However, Infographic Designer is one of the visuals that is not just another visual. This custom visual has some unique features that you cannot see in many other visuals. Read more about Infographic Designer: Not Just Another Visual[…]
One of the recent features in Power BI Desktop is the ability to create your own custom connector and use it when connecting to the data source. This feature looks just one feature, but it opens doors to many possibilities. With this feature you can write your own custom connector to any types of data Read more about Power BI Custom Connector: Connect to Any Data Sources. Hello World![…]
Previously I have written a blog post explaining two ways of combining data sets with each other; Append vs Merge. In this post I want to explain in details what is the difference between all types of Merge Type and explaining how to choose the right merge (or Join) type. These Merge types are very Read more about Choose the Right Merge Join Type in Power BI[…]
Busy schedule in last few months with lots of conferences and courses didn’t allowed me to publish 3rd version earlier. and now, here you go; 3rd edition of Power BI from Rookie to Rock Star book is available to download. this edition ended up with being 1075 pages! This book is already downloaded more than Read more about Edition 3 of Free Book: Power BI from Rookie to Rock Star – 1075 Pages![…]
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[…]
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[…]
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[…]
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[…]
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[…]