Forum Discussion
Mssing data dimensions when creating report from Lakehouse
Hi.
I'm trying to walk my way through the Lakehouse Tutorial.
First of all - too many steps are not accurate anymore, but it seems to be doable.
I'm at section 6, Build a Report https://learn.microsoft.com/en-us/fabric/data-engineering/tutorial-lakehouse-build-report and everthing has been done - sofar.
All steps are done through 1-5, but step 6 requires me to create a report (from a menu item, that is located on a differetn tab). The report opens up only containing one dimension in the data pane: dimension_customer
The originating model layout contains the dimensions required with the references expected.
Why are they dimensions (and fact) missing from the report?
Any help appreciated.
Hi, zapan, hope these pointers help you out.
- Check Lakehouse Model: Ensure all dimensions and facts are visible and relationships are correctly set.
- Refresh Dataset: In the report builder, refresh the dataset to update schema and data.
- Verify Data Source: Confirm the report is connected to the correct Lakehouse.
- Recreate Dataset: If issues persist, rebuild the dataset in Lakehouse and reconnect.
- Sync Issues: Log out/in or clear the workspace cache to resolve sync problems.
4 Replies
Hi, zapan, hope these pointers help you out.
- Check Lakehouse Model: Ensure all dimensions and facts are visible and relationships are correctly set.
- Refresh Dataset: In the report builder, refresh the dataset to update schema and data.
- Verify Data Source: Confirm the report is connected to the correct Lakehouse.
- Recreate Dataset: If issues persist, rebuild the dataset in Lakehouse and reconnect.
- Sync Issues: Log out/in or clear the workspace cache to resolve sync problems.
Hi zapan,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi zapan
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi zapan
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
