topic Re: Accessing SSAS db in node in Custom Visuals Development Discussion

Accessing SSAS db in node

smpa01 — Thu, 19 Oct 2023 12:49:05 GMT

Is there any way to access (to read/query db) the ssas db (hosted on a workspace/localhost) in node.js/ within the custom viz. Does there exist any node module that can do the job?

Currently msnodesqlv8 is capable of querying a sql-server. I have tested it and it is fully legit. I was wondering if there is a similar module exist for SSAS?

Thank you in advance.

Re: Accessing SSAS db in node

d_gosbell — Thu, 19 Oct 2023 21:40:01 GMT

Custom Visuals are usually written in typescript. Custom visuals use the customer visual API to integrate with a Power BI report and there is no facility in that to write custom queries. I don't know if you can even use node modules in custom visuals. And I don't have a lot of experience in node so I'm not aware of whether there are any modules that support SSAS.