m-kovalsky / fabric_cat_tools

Supercharge your Microsoft Fabric development with the fabric_cat_tools library
MIT License
100 stars 14 forks source link

BPA Rule output Values #20

Closed GilbertQue closed 1 month ago

GilbertQue commented 1 month ago

Hi Michael, do you think it would be possible to have an output for the BPA Rules into a value/number.

The reason for this is so that I could run the BAP rules over a semantic model, then get a score. And from that score we could then determine if the semantic model passes or fails?

Thanks for all your amazing work! Gilbert

m-kovalsky commented 1 month ago

How exactly do you envision this? What number would it give? Also maybe take the severity into context?

Also FYI, there is a parameter for this to return a dataframe (which you can transform) instead of the visualization.

GilbertQue commented 1 month ago

Hi Michael, I tried to but could not find the parameter?

If I can confirm the parameter then I am happy with that result?

m-kovalsky commented 1 month ago

See the documentation here: https://github.com/m-kovalsky/fabric_cat_tools?tab=readme-ov-file#run_model_bpa

The parameter is 'return_dataframe'

GilbertQue commented 1 month ago

Thanks Michael, let me give it a go tomorrow!

GilbertQue commented 1 month ago

I can see the output in the Pandas data frame. What I meant to say is instead of the visual icons could I get the severity number?

Or alternatively what the visual icon relates to which severity (I can then create a number value from the icon)

Here is the example below. image

m-kovalsky commented 1 month ago

I put a legend for the severity in the 'Returns' section of the documentation of this function.

https://github.com/m-kovalsky/fabric_cat_tools#run_model_bpa

GilbertQue commented 1 month ago

Awesome thanks for your answers!