Power BI Data Prep with Dataflows

Collecting data for Business Intelligence (BI) reporting can be a massive task, often 60-80% of an analytics project is attributed to just bringing together the data from multiple sources in various formats. The preview of Dataflows in adds to the data preparation capabilities of Power Query in Power BI Desktop. 

• Create data preparation logic through Dataflows that can be reused across multiple Power BI reports and dashboards.
• Create sophisticated data transformation pipelines using a new recalculation engine to automatically track dependencies and recompute data as new data is ingested. This allows analysts to build on each other's previous work.
• Store data in the customer’s Azure Data Lake Storage Gen2 instance, fueling collaboration across roles. Business analysts can seamlessly operate on data stored in Azure Data Lake Storage, taking advantage of its scale, performance, and security. Meanwhile, data engineers and data scientists can extend insights with advanced analytics and AI from complementary Azure Data Services like Azure Machine Learning, Azure Databricks, and Azure SQL Data Warehouse.
• Organizations have the ability to leverage a standardized and extensible collection of data schemas (entities, attributes and relationships) through the Microsoft Common Data Model. 

See the following link for the Microsoft Blog:

Power BI Blog

Tanya Denton

Tanya is the company's Microsoft 365 and Online Services specialist, providing support for existing customers and project managing new installations. From training on Power BI to setup on Microsoft 365, Tanya is experienced in working both as a customer as well as an external consultant.