Using a DataFlow Gen2 in a report

Hi Anonymous ,

Thanks for reaching out to the Microsoft fabric community forum.

Yes, we can create a report from a DataFlow Gen2 in the Power BI Web App but not directly.

There are few workarounds to create reports using Dataflow Gen2. Please follow these steps below to create reports or dashboards:

• After loading data into Dataflow Gen2, specify the destination as the lakehouse and establish the connection.
• Next, select the lakehouse that you have previously created in a specific workspace, and click on New Table.
• You will then see an option labeled Schema Settings; you can choose to keep this setting on Auto.
• Finally, save the settings and publish the changes, as illustrated in the image belows.

Please refer to below documentation for better idea dataflow gen2 to lakehouse:

Copy sample data into Lakehouse and transform with dataflow - Microsoft Fabric | Microsoft Learn

• After publishing the data to the lakehouse, you will notice that a new table has been added to the existing tables. Subsequently, you can utilize the semantic model associated with that lakehouse to create reports or you can create a new semantic model so that you can directly pick that model while creating report.

Follow the below picture your better understanding:

Now, you can see that all my tables has been loaded into the report .

An alternative solution to achieve this. If all tables are integrated into a single lakehouse rather than creating a new semantic model, we can generate reports in the following manner.

• Once the tables are loaded into the lakehouse, you will see the SQL Analytics endpoint option, as demonstrated in the image below.

• Upon opening the application, you will find an option labeled Reporting. Within this section, there is an option called New Report, as illustrated in the image below.
• Selecting this option will automatically direct you to the report creation page, where you can incorporate all the relevant data stored in our lakehouse.
• 

   

I hope my suggestions give you good ideas, If you have any more questions or need further assistance, feel free to let me know.

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thank you