Microsoft Power BI – connecting with Price2Spy API
Home / Microsoft Power BI – connecting with Price2Spy API
Microsoft Power BI is a popular business analytics tool that enables you to do API Queries and Database analytics with very little IT effort. In other words, it allows you to visualize your data from various sources and share insights across your organization with the help of live dashboards and reports.
Since more and more Price2Spy clients want to connect their Microsoft Power BI via Price2Spy API, we decided to share this with you in a simple manual.
There are 2 methods that you can use in order to establish a connection between your Power BI and Price2Spy API.
1. Connecting Power BI to Price2Spy API – GET methods
Important: In case you are sending a JSON object in the Json.FromValue() method you should not send an actual JSON representation. An object here would start and end with square brackets [ ] while the values inside need to use equals sign =.
One more way is to escape a JSON string with double quotes in the editor (see screenshot 6):