Forum Discussion

BiWithMarius's avatar
BiWithMarius
Regular Visitor
2 years ago
Solved

Multi Layer Architecture in Pro

Hi dear BI-fam,    I tried finding a solution in the community but havent come over it yet. So please excuse me if there already is a thread for my problem.    The case:  I currently work as Das...
Dataflow
Need Help
Tips and Tricks
Tutorial Requests
  • BiWithMarius's avatar
    BiWithMarius
    2 years ago

    Thanks guys! Yes the incremental refresh was a premium feature but was introduced to Pro I think earlier this year. 

     

    I posted the same question in the Power BI Subreddit and the user LostWelshMan85 came up with a great solution:

     

    You actualy can reference a previous dataflow in pro, but only the loading part is restricted to premium. What you can do is to load the previous dataflow, deactivate load and then reference it in another table. In that one you can now transform and do your thing. Even refresh is working fine. Just takes a bit of dataflow orchestration and will probably use more of your pro storage, but if the dataset has a decent size, it should be a good workaround. 

     

pmreis's avatar
pmreis
Most Valuable Professional
2 years ago

Hi BiWithMarius 

 

Please refer to What licenses do you need to use dataflows - Power Query | Microsoft Learn for Dataflow capabilities in each of PRO / Premium licenses.

 

Power BI Pro

Power BI Pro gives you the ability to create analytical dataflows, but not use any of the premium features. With a Power BI Pro account, you can't use linked or computed tables, you can't use AI capabilities in Power BI, and you can't use DirectQuery to connect to the dataflow. The storage for your dataflows is limited to the space left under your Power BI Pro account, which is a subset of 10-GB storage for all Power BI content. Currently, we don't report the current storage usage of dataflows in the Power BI portal. You'll be notified if you've almost reached the limit of the left over capacity.

 

You mentioned using Incremental Refresh, which is a Premium feature, and will only work with Premium License.

 


Pedro Reis - Data Platform MVP / MCT
Making Power BI and Fabric Simple

If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!

Find me at LinkedIn