Category: PowerQuery

What are translation tables in Power Query’s Fuzzy Match and why would we need them?

~ Vitali Burla ~ Leave a comment

In Power Query, we have the option to use Fuzzy Match when merging tables. A little known feature are the Translation Tables which help in that process. Merging tables is relatively straightforward in Power Query - choose the left table, choose the right table, mark the columns for the merge to be made onto, choose … Continue reading What are translation tables in Power Query’s Fuzzy Match and why would we need them?

Протеини, който не яде… той данни не ще да събере (или за Power BI, BB Team и здравословното хранене)

~ Vitali Burla ~ 1 Comment

BB Team (https://www.bb-team.org/) e един от най-старите сайтове в българското уеб пространство, поне по мои спомени. Спомням си, че преди около 15 години вече имаше много полезни статии за тренировки, хранене и т.н. Power BI пък от своя страна позволява ефективна визуализация и трансформация на данни и BB Team се оказа чудесен източник - хората … Continue reading Протеини, който не яде… той данни не ще да събере (или за Power BI, BB Team и здравословното хранене)

Passing parameters to Native SQL Query in Excel and Power BI

~ Vitali Burla ~ 1 Comment

Using Power Query in Excel you can parameterize a native query to SQL server or Oracle. While this is not something new, it's very useful as with some simple data validation you can turn your Excel file into a front-end query tool. Here are four simple steps to follow:Step 1a) Write the query code & test it; Step 1b) Paste it into … Continue reading Passing parameters to Native SQL Query in Excel and Power BI