Posts in category

Power Query


In today’s post, we will learn two new techniques to load the Power BI Desktop data to the SQL Server or any other ODBC database. Technique 1 : Using R Script in the Query Editor Window¬† In this technique, we will leverage the power of R in the Query Editor. You can use R script …

The equal allocation of budget is the technique you use to compare budget information at the different granularity with other data such as Sales or Discounts etc.using Power Query. They are an extension of the handling of different granularities in Power BI using the DAX as I discussed in my last blog. In this article, …