import Apigee data into Power BI

[Anonymous]

Hi,

I recently start using Power BI desktop to analyze some datasets.  I have some datasets from Apigee which I'd like to pull into my existing Power BI dashboard to display real-time visualizations.  I know there is a Real-time Streaming, but it requires a Power BI app to be developed and authenticate with Azuare and then push data from Apigee to Power BI, that's a lot of hassle (maybe a sample Apigee-Power BI app?).  Is there an easy way to just pull Apigee data into Power BI?  

Thanks,

Walter

[v-yuezhe-msft · Accepted solution]

Hi @Anonymous，

If you need to display real-time visualizations, it is not an easy task, you would need to utilize Azure Streaming Analytics. You can push data from Apigee to Azure Event Hub, then create Azure Streaming Analytics jobs and output data to Power BI to create a real-time dashboard. For more details, please review this article: https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-power-bi-dashboard .

However, if you don’t persist to have real-time visualizations, based on my research, you can connect to Apigee via “Get Data->Web” entry in Power BI Desktop, then import data from Apigee into Desktop, create reports and publish reports to Power BI Service. This way, you can set schedule refresh for your dataset, reports will be updated based on your schedule.

Thanks,
Lydia Zhang

[Anonymous]

Hi Lydia,

Thanks for the detailed info on Azure streaming and the alternative solutions using Refresh.  For Azure, it's interesting and we will look further. For Refresh, I see the max. refresh rate is every 3 hour during a 24-hr period.  Can it be hourly? 

Best regards,

Walter

[v-yuezhe-msft]

Hi @Anonymous,

No. Schedule refresh is up to eight times  per day.

Thanks,
Lydia Zhang