Forum Discussion
Best approach to modify data set from api to show a line chart?
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.
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.
3 Replies
V-lianl-msftCommunity Support
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.
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?