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
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.
I'm sorry, if I wasn't clear enough.
If I select a new destination, it creates a new Lakehouse connection. But I cannot find that lakehouse anywhere. I don't know how to open it and to work with it.
If I create a new Lakehouse right before I select a destination, then it won't show up in the destinations. I still get the option to create a new Lakehouse connection or to use the one to a Lakehouse I cannot find anywhere.And I tried to find a way to create a connection out of my manually created Lakehouse ... but there seems to be no possibility.
So to model in the SQL analytics endpoint I need to have a lakehouse (which I can find) where to destinate my queries OR a connection to my manually created lakehouse.
Now I hope its more obvious where I'm right now.