Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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://powerbi.tips/2016/06/loading-data-from-folder/
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://powerbi.tips/2016/06/loading-data-from-folder/
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
86 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |