Key Vault is an Azure module, which lets you safely store your secrets/keys. This way your developers do not have to store credentials or connection strings in the code, but can simpy ask Key Vault to provide them. The application will be handed the password and will be able to log in without the developer even knowing it. Let us create a key vault!
Cognitive Services from Microsoft offer pretrained networks that allow citizen developers to quickly develop e.g. image recognition algorithms. This short post is to show how it is done and how I have created a real-time people recognition system. The goal of this solution is to recognize people in our office and possibly inform our beloved founders of this. What I used was: a python script and a FullHD webcam + Cognitive Services Custom Vision API.
Recently, a lot is heard about some additional fees that our government in Poland wants to introduce. This, combined with a discussion among my friends about, among others, income tax threshold, prompted me to check how high the tax burden for employees in Poland and Europe is. I have included everything in one Excel and I hope that you will help me improve it.
I have chosen arbitrarily a few countries from Europe: the Czech Republic, Germany, Sweden and the UK. These are the countries, to which many people migrate and often seen as countries with a higher standard of living, as compared to Poland.
List.Accumulate is a very powerful function that is often overlooked, when doing Power Query transformations. Its basic behaviour is explained in the reference. How this function works is accumulates a result from a specified operation (accumulator function) starting from the initial value – seed – and going row by row till the end of a specified list. Radacad greatly explained the possibilities of the function. I treat List.Accumulate as a function that lets me access a previous row. Something that is very often expected by customers using Excel sheets as data sources. This enables me to e.g. detect a change in ID or date – from my experience 90% of the cases.
This tutorial was requested by one of our clients. His app was connected to DWH, which was the source for the Analysis Services. After the data was input into the edit form, the task was to start processing the table to see it through Power BI.
Today, I will go through how to create a loop function using List.Generate() and a Custom Function. I will show how to loop through pages in an API call. This would normally be solved using a for loop in e.g. Python.
I know that this case might be obvious for the most of the experienced data engineers and other specialists, but it really surprised me. Our Principal Architect in Clouds on Mars – Paweł Potasiński pointed me this possibility.
The case from one of my previous comments had another catch! As I mentioned the client was downloading data from an API. The client was interested in data for multiple entities i.e. had to use different credentials for the same URL to retrieve different datasets. Because the client wanted to see everything in one Power BI I had to find a suitable solution. Same as before, I turned my attention towards M language!
Today’s post shows how to call a custom function for each row in a table. This can be done both using standard Power BI interface and M language scripts. I have decided to try the latter.
