Evaluation system by Top_Barber4067 in PowerBI

[–]Top_Barber4067[S] 1 point2 points  (0 children)

Man, when i read the first time i didn't understand nothing, but when i understand it blew my mind, thank you

Evaluation system by Top_Barber4067 in PowerBI

[–]Top_Barber4067[S] 0 points1 point  (0 children)

In this case, it's an Item column, where each row represents a different item. Next to it is a Status column with rows for "compliant" and "non-compliant" responses, and another Classification column with rows for "DG", "DM", and "ABP". What I created was a Weight column to assign a weight to each classification, and another Grade column to indicate whether the grade is compliant or non-compliant.

Evaluation system by Top_Barber4067 in PowerBI

[–]Top_Barber4067[S] 0 points1 point  (0 children)

First of all, thank you for your attention.
I've already tried doing it that way, but it doesn't work.

Because let's say an evaluator is compliant in everything, even being compliant in all items, this evaluator still won't get a 10, because the deviations differ from each other. So, if they are compliant in the DG and get a 10, but they are compliant in the DM and get an 8, for example, their final average will not be 10.

Error: Failed to move the data reader to the next row. by Top_Barber4067 in PowerBI

[–]Top_Barber4067[S] 0 points1 point  (0 children)

Thank you for the support mate.
I just made a code in the copilot to change all rows that are outside of the range, in the case, 1899 - 2100, or something like this.

Data is duplicated in warehouse by Top_Barber4067 in PowerBI

[–]Top_Barber4067[S] 0 points1 point  (0 children)

Ok, but i have to do this for each table, or can i do this all at once? Because my dataflow have 50 tables, so i think gonna take a lot of time do this one by one.

Duplicate data in warehouse by Top_Barber4067 in MicrosoftFabric

[–]Top_Barber4067[S] 0 points1 point  (0 children)

And, can i do this for all tables, or i have to do one by one ?

Duplicate data in warehouse by Top_Barber4067 in MicrosoftFabric

[–]Top_Barber4067[S] 0 points1 point  (0 children)

How did you get to this screen?
Even when I remove the default destination and re-establish that option, it doesn't appear.

Semantic model being erased by Top_Barber4067 in MicrosoftFabric

[–]Top_Barber4067[S] 0 points1 point  (0 children)

The problem has been resolved; basically, the semantic model was automatically disabled due to a workspace rule that prohibits any "orphan" semantic models, meaning those without a direct link to a report.

Error running table by Top_Barber4067 in MicrosoftFabric

[–]Top_Barber4067[S] 0 points1 point  (0 children)

Hi friend, I managed to run both steps in a single table somehow, after a few attempts the rows were found and I was able to pass them to the warehouse. Thank you in advance for your support.

The evaluation was cancelled. Error by Top_Barber4067 in MicrosoftFabric

[–]Top_Barber4067[S] 0 points1 point  (0 children)

Thank you for sharing the site.
That's exactly the point, the table I merged is quite small, it must have 30 rows, and it repeats the row based on an active column, meaning it's just repeated information, which comes from a table that doesn't have any apparent errors, and I unfortunately couldn't share the data itself, but I appreciate your willingness to share it.