The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredAsk the Fabric Databases & App Development teams anything! Live on Reddit on August 26th. Learn more.
Hi!
I'm very new to this and are following this tutorial https://learn.microsoft.com/en-us/fabric/data-engineering/tutorial-lakehouse-build-report
I have an issue when I'm supposed to build my report. This is how it is supposed to be.
But I can't find more than one table. I have probably made something wrong, but because I'm new to this I don't understand how to troubleshoot this. Doesn't the report include all tables from the model view? Or should I select the table I want in my report?
Regards Oskar
Solved! Go to Solution.
Go to Reporting -> New semantic model.
https://powerbi.microsoft.com/en-us/blog/improvements-for-creating-new-direct-lake-semantic-models/
Don't use the default semantic model.
Use New semantic model instead (a.k.a. custom semantic model).
Hi @oskark ,
When building a report in Fabric, you typically need to select the tables you want to include in your report manually.
Here are a few steps for troubleshooting:
Make sure all the tables you need are in the model view.
Sometimes refreshing the data helps to load all the tables correctly.
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Hi!
The table "fact_sale" is in the model as in the tutorial (see 1.).
I press the button "New report"(2.).
It sends me directly to the report page. On the report page is only one table showing up "dimension_customer"(underlined with green on both pictures).
Should I create the report in another way where the option to select tables pop up? Fabric select this table for me. I have tried to mark table in the model view and then pressing "New report" but it didn't change anything.
Go to Reporting -> New semantic model.
https://powerbi.microsoft.com/en-us/blog/improvements-for-creating-new-direct-lake-semantic-models/
Don't use the default semantic model.
Use New semantic model instead (a.k.a. custom semantic model).
User | Count |
---|---|
16 | |
10 | |
8 | |
4 | |
3 |
User | Count |
---|---|
53 | |
22 | |
20 | |
17 | |
12 |