How to get data from AppCenter, Google Play and App Store to Power BI?

Power BI Online Service
1

Hello guys,

My company is making apps for many businesses. And my boss requires me to get data from these tools (see below) to Power BI, then analyze & visualize the finding in Power BI.

These tools include:

  1. AppCenter of Microsoft ( both on Android and IOS platform) to track the active users (daily, weekly, monthly): this tool works like Google Analytics (but for the app).

  2. Google Play Console: to view impressions, and download (or installed app) data to the listing.

  3. App Store: to view impressions, and download (or installed app) data to the listing.

My question is: How to get data from these 3 tools above to Power BI (desktop or service)?

Do I have to ask the IT guy in my company to set up API, then get the data through API?

Or any other ways to get the data?

Please give advice

Thanks in advance

2

Hi…I could be showing my utter technological ignorance here but I’m not sure this information will be available to anyone other than the individual companies/entities themselves.

You might be able to access data for the individual apps, that the businesses you produce apps for, list on these sites/entities. I think there might be some API’s available to do this.

1 Like
3

@hunghahuy If the applicaton is from your own company then there should be a person who has super admin access and can tell any stats that you need to know, plus the best way to access them regularly.

How does the development works? Your company creates the application and hands it over to the client or your company is in for a long term contract?

1 Like
4

Hi @AntrikshSharma ,

Our company make applications and also handle them for our clients.

I just wonder if API is the only way to get data from AppCenter, Google Play, and App Store or are there other ways?

About the person who is super admin - Yes, we do have him, and I am working with him. But, I just wonder are any other ways to get the data instead of APIs method?

If you have any ideas, please suggest

Thank you

5

Hi @hunghahuy! We noticed that your inquiry was left unsolved for quite some time now.

Looks like your inquiry was out of the experts and users’ bounds.

We strive to answer ALL inquiries in the forum. However, if you are sure that you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, you can check out tutorials to learn this yourself as your membership also comes with relevant resources that may help you with your Power BI education.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!