Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

How to connect Azure Analysis Services as a data source

Answered
Gaurav Jain 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

1 answer

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 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 Directory
  • AZURE_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

Please login or Register to Submit Answer