Sign-up now and get instant access
Leave a comment
Customized training to master new skills and grow your business.
Beginner to advanced classes taught by Microsoft MVPs and Authors.
In-depth boot camps take you from a novice to mastery in less than a week.
Season Learning Pass
Get access to our very best training offerings for successful up-skilling.
Stream Pro Plus
Combine On-Demand Learning platform with face-to-face Virtual Mentoring.
Quick references for when you need a little guidance.
Summaries developed in conjunction with our Learn with the Nerds sessions.
Digital goodies - code samples, student files, and other must have files.
Stay up-to-date on all things Power BI, Power Apps, Microsoft 365 and Azure.
Community Discord Server
Start here for technology questions to get answers from the community.
Earn money by driving sales through the Pragmatic Works' Training Affiliate Program.
It's time to address your client's training needs.
Learn how to get into IT with free training and mentorship.
Discover the faces behind our success: Meet our dedicated team
How can we help? Connect with Our Team Today!
Find all the information you’re looking for. We’re happy to help.
Is there a simple process for converting your existing datasets into a dataflow? The answer is yes, and I’ll share some tips here for doing this in the Power BI Service without having to do a lot of rework.
Why would I want to do this, you may ask? It makes sense in a few scenarios.
Scenario 1: Converting Existing Datasets to Dataflows
Scenario 2: Preferring the Power BI Desktop Experience
Scenario 3: Dataflows from SQL Statement
Now let me walk you through my process. There’s one thing you must understand about dataflows and a requirement for the data gateway. The Power BI service needs to have connectivity to the data source for your dataflow.
If that dataflow source is a SQL Server that exists in an on-premise data center, you’ll need to have your gateway configured so that the Power BI service has a way to get connected to the database. There are many resources out there that can show you how to do this.
At this point, I suggest you watch my video below as I’ll walk you through a demo of the process for converting your existing datasets into a dataflow. It will be easier for you to see it done then to explain the process.
For help in incorporating dataflows or Power BI in general into your organization, we’re here to help. Our data and Power BI experts can help you in any stage, from knowledge to roadmaps for success to implementation. Contact us or click the link below.
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.