Fabric Utils

A collection of Microsoft Fabric utility notebooks to solve common challenges in Data Engineering and Fabric/PowerBI administration.

📂 Notebooks

1. Fabric XMLA Utils (fabric_execute_dax_xmla.ipynb)

Enables the execution of DAX queries via the XMLA endpoint.

This utility solves the limitation where standard sempy functions and REST APIs error out when trying to handle Row-Level Security (RLS) enabled datasets when authenticated as a Service Principal. It uses the .NET AdomdClient to ensure reliable connection and security context switching.

---

🚀 Getting Started

1. Download the desired .ipynb file from this repository (e.g., fabric_execute_dax_xmla.ipynb).
2. Go to your Microsoft Fabric Workspace.
3. Click New -> Import notebook.
4. Upload the file.
5. Configure the variables (e.g., workspace_name, dataset_name).
6. Run the notebook!

---

🛠️ Tool Documentation: Fabric XMLA Utils

Prerequisites

To use this notebook successfully, ensure the following configuration:

• Service Principal: Must be an Admin, Member, or Contributor in the target workspace.
• Capacity: Premium (P-SKU) or Fabric (F-SKU) capacity (required for XMLA endpoint access).
• Tenant Settings (Admin Portal):
  1. Developer settings -> Allow service principals to use Power BI APIs: Enabled (Allows SP login).
  2. Integration settings -> Allow XMLA endpoints and Analyze in Excel: Enabled (Allows XMLA connectivity).