The Antares Alien

When working with Power BI, sometimes the refresh speed is excruciatingly slow.

I was recently working on a project where there were over 28 thousand tables in the database.

Here's the situation: I have a list of values (text/string). I want to create one single concatenated string based on that list.

The alien walks us through a comparison of increases in tourism per country per year. Also go over some Power Query and DAX tips including A

Power BI has a somewhat hidden feature you may not have know existed - or maybe you knew about it but haven't given it a thought to try

Why Power Query doesn't give you the option to expand a merged table with both non-aggregate values AND aggregate values. Let's take

This is a collection of Power Query / M functions that I've used in the past. I'm using this article as an open collection so that y

​How do the top 10 companies in GA and their respective tax payment in 2018 line up? Plus, a look at nesting queries within queries.

You may already be familiar with the "Get Data" function in Excel. You can use this feature to send data from your worksheet to Po

Read about how to create a Python function in Power Query!

Read about how to make a Power BI dashboard to help you make a decision on the best countries to visit for a Digital Nomad Excursion!

Find out how you can write Python code inside the Advanced query editor with Python.Execute()

Read about how to prevent errors resulting from column name changing.

Create easily editable parameters in Excel for Power Query to help your users. Use a named range in Excel for the query source. You can then