Forum Discussion

desott's avatar
desott
Regular Visitor
3 years ago

Read a dataset directly from a NodeJS app

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?

Need Help
Tips and Tricks
Tutorial Requests

3 Replies

    • desott's avatar
      desott
      Regular Visitor
      3 years ago

      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?

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

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