Forum Discussion
Unexpected parquet exception occurred. Class: 'ParquetStatusException'
Hi Anonymous ,
I think I found the root cause about your problem which I also had.
I found that this issue happens when I add 'category' from 'DimProduct' and never happens when I add 'SalesTotal' from 'FactSalesOrder'.
So, I explored the workspace first in the left pane.
When you click the workspace, for me it is 'dp_fabric', you can see a similar image to the below:
Then you will see there is a semantic model, the number 2 in the red circle of the above image.
Click the semantic model, you will see a modal like window in the right pane.
Then click 'View item details' in the green button, the number 3 in the above image.
You will see another page of 'Details for <<your semantic model>>' and there are information about Tables in the right pane.
When I tick the table of 'DimProduct', I found that the values of 'DimProduct' was not visible and there's the '404' error about the table.
So, I thought that there was some problem when I create the table of 'DimProduct'.
There must have been a trouble when I created the table.
Since I found the root cause of the problem, I made a hyperthesis to fix by making another query to create the table.
Move to the warehouse by clicking the warehous in the left pane.
First, I need to delete the relations between the existing "FactSalesOrder" and "DimProduct" before creating the "DimProduct" table again.
Because of the relationship, you cannot recreate the table without deleting the relationship.
I deleted the visual query by right-clicking 'Visual query 1', just in case.
Now the time to re-create the table of 'DimProdut' by running the proper query.
For me, it was SQL query 3.
After getting the message that the query succeeded, make the relation between 'FactSalesOrder' and 'DimProduct' again.
Make another visual query as well.
Move to the semantic model again to check if the error has been fixed.
I can see the table was fixed.
Let's check if the error fixed in the report as well.
Move to the warehouse and click model to creat a new report.
(It may ask you sign in)
Threre's a blank report page.
Select 'clustered bar chart'.
Add the relevant data into the chart.
Y axis --> Category from DimDate.
X axis --> SalesTotal from FactSalesOrder.
Adjust the size of the chart just like the below image.
I hope this help you.
If it works, would you take this answer as the verified answer?
I tried your method and didn't work, even the semantic model is fixed but when tried to work in Power BI same error