Forum Discussion
Connecting to Magpi
Hi,
Does anyone have an idea how to connect Power Bi to Magpi data source? I used Magpi (www.magpi.com) to collect survey data and I want to import it to Power BI for analysis. Thanks for any help here.
Kind regards
2 Replies
- pqian
Microsoft Employee
Looks like MagPi supports exporting data through Excel, follow the guide here
http://support.magpi.com/support/solutions/articles/4886-exporting-data-from-the-magpi-website
once exported, you can import the data into PBI and analyze it
- gnuoryxFrequent Visitor
pqian, Thanks Pquin, I actually used the export feature n Magpi. It's just that I didn't want to keep exporting data every time as "new" exporte data; I wanted to link my Magpi data with Excel and only have to refresh each time to get updated records in Excel. However, I checked Magpi and they said the feature is available for Enteprise users through the use of Magpi API from the enterprise user account. Since I do not have an enterprise user accout I guess I will have to figure it out. Thank you again for assisitng.