Premium per User Dataflow, Pro-license users

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