Have you ever wanted to match two tables together but not on exact matches, but also on a threshold of similarity? if your answer to this ques...
Finding rows that are in one table, but not the other is one of the most common scenarios happening in any data related applications. You may ...
As I mentioned earlier in Power BI online book, Power Query is a functional language. Knowing functions is your best helper when you work with...
Aggregation can speed up the performance of DirectQuery sourced tables significantly. To use it, firstly, you need to create an aggregation ta...
In Microsoft Fabric, the Data Factory is the workload for ETL and data integration, and the Data Pipeline is a component in that workload for ...
Although this seems to be a simple thing to do, it is not a function that you can turn on or off. If you have a Dataflow that does the ETL and...
One of the questions I often get these days is what are the benefits of Microsoft Fabric for Power BI users and developers. Questions like: &#...
If you want to get Microsoft certifications in the Fabric and Power BI space, there have been some changes in the past few years, especially w...
Unfortunately, there isn’t a migration tool to convert your Power BI dataflow (gen1) to Microsoft Fabric dataflow (gen2). If you have Fa...
Power BI offers a new type of connection to Microsoft Fabric Lakehouse or Warehouse, called Direct Lake. The Direct Lake connection acts like ...
