Try to use fabric_cat_tools

[Devis1996]

Hello! First of All, thank you for fantastic tools. I try to use fabric_cat_tools method run_model_bpa, but i find this error: KeyError: "None of [Index(['Hierarchy Name'], dtype='object')] are in the [columns]"

I don't understand why thi heppened. Versions: Runtime 1.2 Spark 3.4 Delta 2.4

I attach the screen of code.

Thank you!

[m-kovalsky]

A bit more context would be helpful but let's start with this. Would you run the following code and show me the headers for the columns:

import sempy
import sempy.fabric as fabric
fabric.list_hierarchies(dataset = 'Daily Sellout')

[Devis1996]

I attach the result:

[m-kovalsky]

Please send the entire error message

[Devis1996]

I attach entire error message error.txt

[m-kovalsky]

I'm not able to reproduce this error. Are you able to share your .bim file (over email)?

[Devis1996]

The customer doesn't allow me to send the .bim, sorry

[Devis1996]

I simplified the Model but I got the same error. Please leave me the email address so I can send you the .bim? Thanks for the support

[m-kovalsky]

@.***

---

From: Devis1996 @.> Sent: Wednesday, April 10, 2024 3:50:25 PM To: m-kovalsky/fabric_cat_tools @.> Cc: Michael Kovalsky @.>; Comment @.> Subject: Re: [m-kovalsky/fabric_cat_tools] Try to use fabric_cat_tools (Issue #1)

I simplified the Model but I got the same error. Please leave me the email address so I can send you the .bim? Thanks for the support

— Reply to this email directly, view it on GitHubhttps://github.com/m-kovalsky/fabric_cat_tools/issues/1#issuecomment-2047455902, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AHBQBNXRU7FUVD7GJXH6XUTY4UYRDAVCNFSM6AAAAABF6BUA7SVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANBXGQ2TKOJQGI. You are receiving this because you commented.Message ID: @.***>

[Devis1996]

Thank you!

---

Da: m-kovalsky @.> Inviato: mercoledì 10 aprile 2024 15:22 A: m-kovalsky/fabric_cat_tools @.> Cc: Devis1996 @.>; Author @.> Oggetto: Re: [m-kovalsky/fabric_cat_tools] Try to use fabric_cat_tools (Issue #1)

@.***

---

From: Devis1996 @.> Sent: Wednesday, April 10, 2024 3:50:25 PM To: m-kovalsky/fabric_cat_tools @.> Cc: Michael Kovalsky @.>; Comment @.> Subject: Re: [m-kovalsky/fabric_cat_tools] Try to use fabric_cat_tools (Issue #1)

I simplified the Model but I got the same error. Please leave me the email address so I can send you the .bim? Thanks for the support

— Reply to this email directly, view it on GitHubhttps://github.com/m-kovalsky/fabric_cat_tools/issues/1#issuecomment-2047455902, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AHBQBNXRU7FUVD7GJXH6XUTY4UYRDAVCNFSM6AAAAABF6BUA7SVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANBXGQ2TKOJQGI. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHubhttps://github.com/m-kovalsky/fabric_cat_tools/issues/1#issuecomment-2047533753, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ALPF34CW2CGQOTSZALPFQ2LY4U4JNAVCNFSM6AAAAABF6BUA7SVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANBXGUZTGNZVGM. You are receiving this because you authored the thread.Message ID: @.***>

[m-kovalsky]

Please check but I believe this should be resolved in 0.2.5

[Devis1996]

Thanks, now a result is displayed. There is a problem reporting errors in calculation items. It is reported that the expression is missing, which is not true:

[m-kovalsky]

Ah, you are correct. Stop and restart the session and try running 0.2.5 again.

[Devis1996]

Now everything is ok, thanks for the support!

Devis