Forum Discussion
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
Most of the tiles in a dashboard (dashboard based on Power BI terms) are from an existing report. Reports cannot directly connect to a dataflow in the service but in desktop. Even for DF gen2, they need to be loaded to a destination first, build a semantic model out of them and then build reports on top of these semantic models.
danextian wrote:[...] Even for DF gen2, they need to be loaded to a destination first, build a semantic model out of them and then build reports on top of these semantic models.
Can you give me a hint please how to achieve that? I just had a clue about semantic models but i stuck. Power BI isn't quite intuitive.
What do you mean with "need to be loaded to a destination first" and how to build a semantic model out of it?
Thank you in advance.
If you are on Fabric, you can select a destination to load a DF gen2 to
The tables below were from dataflows loaded to a lakehouse
These options are not avaible with a pro license so you can only use a dataflow using the desktop app.
Oooohh ... it's quite hard to find everything. There's nothing intuitive here.
I put two of my queries into a destination. The first one into a new Lakehouse connection. The second one into the newly created Lakehouse. So far so good.
I thought I'd find the lakehouse in the left handed navigational side bar under "OneLake" but nothing. I didn't find it somewhere else.
So I thought "create a lakehouse first and use it as a destination then." And I did. I shows up in "OneLake" but it doesn't in the destinations.
I'm lost right now. I had a very good start with the DataFlow but I'm really stuck. 🤣
In my previous reply, SQL Analytics Endpoint is selected (upper right corner). That's where you can model.