Scripting Capability in PowerBI to Access REST Web Services

[david_kero]

We have a few clients that have asked for a BI solution using Power BI. For security reasons we would need to host the reporting data in another environment because there is no direct access to the SQL database. They only way is via a REST style web service. Since PowerBI does not already have that capability we cannot fulfill our clients' requests. For security reasons the clients do not want their data hosted in another environment either. Everyone would win if we are able to interact with REST style web services from within PowerBI to pull the data into PowerBI

[nishalit]

Thanks for the feedback - You can already interact with REST services by using Power BI Desktop and the Web connector. Simply provide the URL REST API call. Power BI Desktop will retrieve and parse the output (i.e. JSON), allowing you to then work with the data just like with any other data source.