When we include a data source inside a data flow it always requests a dataset. The dataset, in turn, requires you to point to a table. A dataset can’t be defined over a query, it needs an object on the linked service, which may be a table or view as you may notice on the … Read more
.There are some interesting ways to transform queries from Power BI Desktop to Power BI dataflows in the portal. The UI can be a bit confusing. I made some mistakes in the middle as well. Let’s see some options to make the conversion. Leaving Blank Query Blank Create a new dataflow Select Blank Query as … Read more
Power BI dataflows is a powerful self-service ETL tool. However, some features demand the use of Power BI Premium, way more expensive than the PRO version and sometimes inaccessible. One of these tasks, for example, is the merge of two tables. Even in the same dataflow, if you have two tables and make the merge, … Read more
Learn how to get maximum performance out of the dataflow task with an extract from Kirk Haselden's popular book on Microsoft SQL Server 2005 Integration Services.… Read more
