In this article you will learn to make a Fabric Notebook accessible via the Fabric API, and run it through a Fabric Notebook package in Exmon.

In the Azure Portal, we need to create an App registration which we will use to access the Fabric Workspace. This is done under the Azure Portal -> Azure Active Directory -> App Registration

1. Go to the Azure Portal
2. Open App Registrations
3. Select New Registrations
4. Name your app and click Register
5. The next window presents some key information that Exmon will use to authenticate for later execution
6. In the left panel, click Certificates & Secrets
7. Then select New Client Secret
8. Add an appropriate description and click Add at the bottom of the window
9. Copy the secret value by clicking the Copy to Clipboard button

Add App Registration and user access to Fabric Workspace

1. With a Notebook already created under your Fabric Workspace you will need to grant at least Contributor access to the Workspace to a user that will be used to authenticate between the DG package and Fabric. This user should be a service user, not used for other tasks, and must not have Multi-Factor Authentication enabled, as authentication is performed each time a package is run and therefore using an MFA user in a scheduled or otherwise unattended run would result in a timeout failure.
2. Grant at least Contributor access to the App Registration created before.

Grant Access Scopes to App Registration

Open the App Registration and select API Permissions in the left panel. Select Add a permission, and then add the following scopes at minimum:

1. ReadWrite.All
2. Execute.All
3. ReadWrite.All
4. Execute.All
5. ReadWrite.All

Create package in Exmon DG

1. Next, open up Exmon
2. Right-click Data Providers, select New -> Data Provider
3. Select a name for your Data Provider
4. Fill in a Description for your Data Provider
5. Select the Exmon System in which your Data Provider should run
6. Under Datasource Type, select Microsoft Fabric
7. Fill in the Tenant-Id, App-Id, Client Secret, User Name and Password
8. Click Save
9. Right-click packages, select New -> Microsoft Fabric Notebook BETA

   

    

10. Select a name for the Microsoft Fabric Notebook package
11. Select the newly created Data Provider, which should fill in the Fabric Notebook dropdown
12. Choose the Notebook to run
13. If necessary, fill in parameters required by the Fabric Notebook in the text field in JSON format:
    { “ParameterName”: “ParameterValue” }
14. Click Save
15. Finally, run the Microsoft Fabric Notebook Package