Adriatic BI company specialized in PowerBI / PowerApps / Excel

20+ international and domestic clients
Implementation and Education!

List.Generate() and Looping in PowerQuery

In this blog, we will explain an advanced topic about the M language – using List.Generate to loop over a table. We will combine our knowledge of lists, records, functions, iterations, and looping techniques. Basically, every important object in PowerQuery. Do-while Loop in PowerQuery Do while loop is commonly used...

Read more

Using M to dynamically change column names in PowerQuery

In this article, we are going to talk about cleaning and transforming column names dynamically and in a bulk. The article was inspired by a request from a client who had issues exporting data from its data warehousing program to .csv files. Out of an unknown reason, program was adding...

Read more

Incremental refresh using PowerBI pro and Dataflows

 In this article, we will see how we can use the self-referencing technique and Dataflows to create incremental refresh with PowerBI Pro version. This technique is tested and working both with cloud and on-premises data sources. In case you are using on-premise data sources to access new data, you need to add on-premise source...

Read more

Pivottables inside the PowerBI – the DAX way

 In this article, we will see how we can use the self-referencing technique and Dataflows to create incremental refresh with PowerBI Pro version. This technique is tested and working both with cloud and on-premises data sources. In case you are using on-premise data sources to access new data, you need to...

Read more

WE HOLD

Microsoft certificate for being experts in BI reporting.

8+ YEARS

With modern Microsoft tools for data manipulation and analysis (PowerQuery, DAX).

4+ YEARS

of experience working with the PowerBI environment.

MORE THAN 20

Satisfied domestic and international clients.

Learn With Exceed Academy

Improve your skills in our Exceed Academy, tailored for both beginners and professional.

Scroll to Top