Premium per User Dataflow, Pro-license users

[Ingo_BI]

I have a client where I need to use Dataflow to ingest and transform the data before loading my PBIX-file.

I need to do some appending and merging in Dataflow which requiers Premium per user-license (20USD/month). However, I want to publish the reports to a PRO workspace so that the end users only require a PRO-license (10SUSD/month). 

Is it possible that only my license is Premium and I use that to create my Dataflow (incl. merge and append) but the end users that use reports that uses the dataflow only have Pro? 

[Martin_D · Accepted solution]

Hi @Ingo_BI ,

One of the core constraints of the Premium per User (PPU) offering is that only users wiht PPU license can access PPU content (including Dataflows, Datasets, and Reports consuming this data). So loading PPU data directly into a report in a Pro werkspace is not part of the offering.

You can think about some workaround:

You can link a datalake to the PPU workspace as the storage container for your dataflow data. Since this is just csv files, you can then ingest from data lake to Pro workspace.

You can also create a PPU dataset from the PPU dataflow tables and then read the data from PPU dataset, e.g., using PowerShell automation or Power Automate (accessing the data with one PPU license) and store the data somewhere where your Pro dataset can read it, e.g., Azure Datalake Gen 2 or SharePoint.

You could also add a copy of your reports for the Pro workspace to the PPU workspace, run scheduled refresh in the PPU workspace, and then automate downloading the refreshed files from PPU workspace and publish to Pro workspace without running the refresh in the Pro workspace.

As you can see, there are many workarounds to chose from. The Microsoft default offering would be to assign all users to a Premium workspace. The "small" version of this would we to subscribe to an Azure F2 consumption based Fabric capacity. Then you can use Dataflow Gen 2 for ETL and Pro license for the consumers is sufficient. Otherwise, that's hard to solve without a workaround.

Kind regards,

Martin

[jochendecraene]

@Martin_D  Is this also the case with apps? Can a pro-license user acces an app that contains content created in a ppu workspace?

[Martin_D]

@jochendecraene No this is not possible. This limitation also includes referenced content, e.g., a report in a pro workspace that is bound to a semantic model in a ppu workspace will show no data.