Integration eBay-API with R?

[powerbipowerbi]

Hello,

Im a professional eBay seller and I want to create a Report about my eBay Traffic and Sales within PowerBi. Therefore Im going to use the eBay Analytics API. 

Following problem:

Getreport calls from the eBay API only allows reports within a dateframe of 90days. I would like to keep my historical data and update the new data on a daily basis.

So my question:

Is it possible to add data from the latest API call to an existing dataset? I was thinking about using a R-Script for making the API call and adding/ saving the data from the last call. Does this make sense? Are there any smarter soulutions for this, e.g. by using the advanced editor in PowerBi?

Regards

a powerbi user

[v-yuezhe-msft]

@powerbipowerbi,

An alternative is to connect to your Power BI model to DAX Studio, then extract the history data into .txt files and put files in folder, then connect to the folder in Power BI Desktop. For more details, please review the following similar thread.

https://community.powerbi.com/t5/Desktop/Save-old-and-append-updated-data-into-an-additional-table/t...

Regards,
Lydia

[powerbipowerbi]

@v-yuezhe-msft

Thank you for that hint. I will definitly take a closer look at this.

Concerning the R-Script, I would like to use Power Bi Service with frequently and automaticly update data. So im thinking about the following process:

Code API requests via a R script -> Execute the R script in Power Bi Desktop -> Save the Power Bi Desktop file in Sharepoint and conntect the file with Power Bi Service -> Updating with Power Bi Service

Could this work? Will an update in Power Bi Service execute the R script automaticly? 

I hope its clear what I mean. Thank you!

Edit: Am I overlooking something? Maybe I could use the Power BI-REST-API to push the latest data into Power Bi?

 

[v-yuezhe-msft]

@powerbipowerbi,

Based on this article, you can use on-premises gateway(personal mode) to refresh the R source. Once you set schedule refresh for your dataset,  the update is automatically based on the schedule.

In addition, you mention the Power BI REST API. Yes, you can use Power BI REST API to push data into a dataset and create a real-time dashboard, and meanwhile you can store historic data. For more details, please review this article.

Regards,
Lydia