Visualize Data in a Lakehouse

Question

Hi all. I'm self-studying to sit the DP-900 certification exam and when going through the Explore Data Analytics in Microsoft Fabric exercise I got stuck with a table showing a red triangle with an exclamation mark in it, which isn't allowing me to use it to create a new report in Power BI Report Design. Would anyone be able to help me solve it? Thank you.

Screenshot 2024-03-04 at 10.35.55

Answer

Hi Fabiana Bertini,

Thank you for contacting us on Microsoft Q&A forum.

Please follow the below steps to troubleshoot the issue:

Step1: Left side pane under Explorer, we can see only “dimension_stock_items” table. Please consider only that table. Ignore Whatever right side highlighted tables.
User's image

Step 2: Try to create a view with below query (Kindly refer this link:

https://microsoftlearning.github.io/DP-900T00A-Azure-Data-Fundamentals/Instructions/Labs/dp900-04b-fabric-lake-lab.html#visualize-data-in-a-lakehouse )

SELECT Brand, COUNT(StockItemKey) AS Products

FROM dimension_stock_item

GROUP BY Brand

Step 3: try to make a relationship between brand from “dimension_stock_items” table to brand from “View”. Please refer below screenshot.
User's image

Step 4: start design a report, Select the New report, It can load the table and the view to Power BI report designer.
User's image

If the information is helpful, , please accept the answer by clicking the "Upvote" and "Accept Answer" on the post. If you are still facing any issue, please let us know in the comments. We are glad to help you.

We value your feedback, and it will help us to assist others who might have a similar query. Thank you for your contribution in enhancing Microsoft Q&A.

Thank you.

Answer

Hi Mahesh.

Unfortunately, I'm still having the same problem. I've tried to go back and start again from when I run the SQL query but the result is the same.

You've suggested that I should make a relationship between the brand from “dimension_stock_items” table and to brand from “View”, but I'm not sure how to do this as there's no value on "MyLakehouse - Views".

Screenshot 2024-03-08 at 09.46.24

But as you can see also, my table shows a red triangle sign with an exclamation mark that your table doesn't have and it makes me feel that this is what's causing the problem for me to go ahead.

The result is the same as I've sent before, a message saying that 'Cannot load model'.

Thank you very much for trying to help anyway.

Kind regards.

Fabiana

Answer

Hi Mahesh.

Thank you very much for your help. When I tried to follow the steps you suggested, after trying to 'Save as View' I got the following message:

Screenshot 2024-03-11 at 13.54.03

Could you assist me from here? Thank you.

Kind regards.

Fabiana

Answer

Hi Mahesh.

Thank you for detailing the explanation. I did 'Save as View' but I'm not sure how to make a relationship between the brand from the “dimension_stock_items” table to the brand from “View”. Anyway, I tried creating a 'New report' and the same message persists. I'm sending below also the error details. Screenshot 2024-03-12 at 08.55.39