Skip to the content

Power BI Data Prep with Dataflows

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 an expert in Office 365, SharePoint Online and associated products such as Power BI. As an expert in CSP (Cloud Solutions Provider), she is knowledgeable about licencing and the state of the market as well as product functionality.

comments powered by Disqus

I find their approach to our relationship very professional whilst being refreshingly realistic. We now consider them to be part of our team

Lee Crowhurst, Technical Director

Partner with the Experts

With over 200 years of combined experience in Microsoft business solutions, our team will help to get you up and running, as well as building a partnership that keeps you supported, all from our UK offices. 

From functionality and licencing to business strategy, we like your questions; contact our experienced team for open, honest and reliable advice so that we can find the answers.