topic Read a dataset directly from a NodeJS app in Developer

Read a dataset directly from a NodeJS app

desott — Thu, 13 Jul 2023 17:29:14 GMT

Hi, is there a way to read directly from a dataset on the Power BI service, without relying on power automate and a CSV file?
I´m not sure if the nodeJS SDK is up to date https://powerbi.microsoft.com/en-ie/blog/pbie-nodejs-sdk/
I already have the flow implemented in Power automate

The first flow reads the dataset, then extracts the data into a CSV file.
Then a second flow reads the CSV file, generates a JSON object, and provides an API that can be read from the nodeJS app.

Is there a way to get rid of power-automate and read directly from the dataset?

Re: Read a dataset directly from a NodeJS app

lbendlin — Sun, 16 Jul 2023 14:01:44 GMT

Can NodeJS read from an Analysis Services data source?

Re: Read a dataset directly from a NodeJS app

desott — Tue, 18 Jul 2023 20:47:36 GMT

Hello there, thanks for your reply, but I'm unsure if I follow your question about what type of Analysis Service, and how does it relate to the issue?

Re: Read a dataset directly from a NodeJS app

lbendlin — Tue, 18 Jul 2023 20:58:46 GMT

Power BI Datasets can be accessed as SSAS Tabular "cubes", and you can run DAX or DMV queries against these.