asked on September 1, 2020
Hi, we want to connect our azure analysis service tabular model as a data source to flex-monster to have web pivot table option through the UI.
We tried the trial version but it didnt work. Can you share us the steps/tutorial for making it work?
Regards, GJ
⋅ September 1, 2020
Hello,
Thank you for reaching out to us.
We recommend using Flexmonster Accelerator for connecting to Azure SSAS.
Please see the guide on configuring the Accelerator in our documentation.
We want to draw your attention to the additional configs required for Azure:
AZURE_AUTHORITY - Azure authority URI (e.g. https://login.microsoftonline.com/<your_domain>)AZURE_CLIENT_ID - Client ID of the service principal registered in Azure Active DirectoryAZURE_CLIENT_SECRET - Client secret of the service principal registered in Azure Active Directory
After configuring and launching the Accelerator you need to establish the connection from the client-side.
Please refer to step 4 of the earlier provided guide to find the corresponding code snippet. It demonstrates the way to connect both to cube and tabular models.
The value of the proxyUrl property should match the URL to Flexmonster Accelerator, including the port specified in the PORT property of the flexmonster.config file.
Please let us know in case some exact problems arise while following the steps above.
Our team is looking forward to hearing from you.
Kind regards,
Illia