Getting app store (apple) sales and trend data into Power BI dataset

[Anonymous]

Hi,

I am trying to get app store (apple)'s sales and trend data into Power BI dataset using desktop. I can log in to apple app store and download the reports manually into CSV file, then access this CSV file from Power BI. Does anyone know how to automate this process? 

Thanks 

[v-diye-msft · Accepted solution]

Hi @Anonymous 

you could use web connector in Power BI.

https://datachant.com/2017/03/30/web-scraping-power-bi-excel-power-query/

But it seems Power query doesn't support to download the files from web automatically.

or you could create a workflow to download the csv files automatically and connect to the folder where stores the csv files with Power BI.

https://powerusers.microsoft.com/t5/General-Power-Automate/Downlaod-csv-file-from-weblink/td-p/26105...

https://powerbi.tips/2016/06/loading-data-from-folder/

[Greg_Deckler]

What is the authentication mechanism, some form of proprietary Apple ID? That's likely to be your sticking point. If some kind of standard authentication is supported, like OAuth, should be fine. Otherwise, toast.