A real loop function in 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.
SQL Injection in Power BI Service
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.
Authenticating to a datasource with multiple credentials
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!
Looping through a table to get data from Web in Power BI
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.
Connecting to Numbeo.com table
The data module in Excel is sued to connect to the table on the websites. In this way, when refreshing, the data will be automatically downloaded and always up-to-date.
Learning how to play Flappy Bird using ANN and genetic algorithm
I decided to try creating a self-learning algorithm on a simple problem. I know that the solution is an overkill, but nonetheless I wanted to explore the possibilities connected to using GA with ANN.
Flights during a storm
This vizualization took way more time than I expected. The idea came up on 29th June, when I was sitting in Microsoft’s office right next to the airport in Warsaw. The storm during that afternoon was huge. I immediately checked flightradar24 to see, what the airtraffic looks like. I wondered what it would look like if plotted with the clouds and maps.
Delete from FTP using Azure Data Factory
During development of an ETL process in Azure Data Factory, you may come across a need to delete the data from FTP. It may be neccessary e.g. when you want to make place for new incoming data or you don’t want your pipeline to pull the old data twice. The solution of the problem lays in a custom activity.
Change units with slicers
Today I will show you a simple solution enabling the change of units/currencies or other perspectives using slicers. This will make a report more responsive and cleaner. From my experience, customers will be able to find the insights they are after much quicker. The end effect will look like this:
