topic Re: Best approach to modify data set from api to show a line chart? in Developer

Best approach to modify data set from api to show a line chart?

Sergio_DG — Mon, 24 May 2021 16:34:16 GMT

Hello,

I have a dataset that was uploaded via csv to power bi desktop. Then I publish the data set to Power Bi Service to generate a report and display it in my app through the code of Power Bi Embedded Samples repository.

Now I want to modify that data. I tried this approach:

Making a post of my data in form of JSON to a dashboard tile with streaming service, (to not use Azure AD auth). The problem was that once the data was up, I couldn't draw it properly. The line chart didn't allows me to pass 2 data columns and a legend. (so I didn't moved forward on how to show the dashboard in my app).

Basically what I want is a way to modify data (add and remove rows) before showing in my app the correponding chart, and showing it properly (line chart with 2 values and a legend).

So:

¿Is there any way I can draw a line chart with pushed data with 2 values and a legend?

¿Is there a way I can modify data programatically that was published from power bi desktop and draw the line chart with 2 values and a legend?

Is it possible to do this using only NodeJS code? without Azure AD oauth?

In general, what is the best approach to do this? Dirty or clean.

Re: Best approach to modify data set from api to show a line chart?

V-lianl-msft — Thu, 27 May 2021 06:50:26 GMT

Do you mean that you use a field of the new dataset as legend after merging the dataset?

As far as I know, there is no such Rest API. You can only merge the data sources through desktop, then re publish the report, and then update the app in the application.

https://www.poweredsolutions.co/2019/04/09/combine-or-append-data-in-power-bi-power-query-main-concepts/

Re: Best approach to modify data set from api to show a line chart?

Sergio_DG — Thu, 27 May 2021 14:23:27 GMT

Hi V-lianl-msft, thanks for your reply,

Yes, I sent a table with 2 columns, 2 of values and 1 for the legend. I did it via data streaming in a tile, but once the data hits the tile, it only allows me to draw 1 value and the legend. Is there any way in general to achieve drawing the 2 values and the legend? or any workaround?

Re: Best approach to modify data set from api to show a line chart?

Sergio_DG — Thu, 27 May 2021 14:24:04 GMT

Sorry, a table of 3 columns. 2 of numeric values, and 1 legend