Other - Power BI Connection

What does Microsoft Power BI do?

Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet or a collection of cloud-based and on-premises hybrid data warehouses.

Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end-users to create their own reports and dashboards. It is part of the Microsoft Power Platform.

The following documentation describes how best to connect to Microsoft Power BI.  Please be aware that Palace expertise does not extend to the use of Power BI other than to connect our API services.  Please contact Microsoft or related 3rd parties that specialize in Power BI if you require further training in this area.

 Pre-requisites:  You must have the latest version of Microsoft Power BI to follow the documentation published below.

• Open PowerBI, select 'Get Data' and then 'Web' from the following menu...

• Select 'Basic' from the following menu and type in any endpoint described in our REST (XML & JSON) API documentation (Example below...)

• The 'Access Web content' menu will then be displayed.  Please select 'Basic' and type in an API 'Username' and 'Password' provided by Palace as well as the base URL (https://api.getpalace.com).  If you do not have authentication details, please request one at api-feeds@getpalace.com for your company.

• If you have selected an endpoint that returns records you should receive a query that you will be able to convert to a table by right-clicking on the 'List' and converting to a 'Table' (Then expand).

Please contact experts in Power BI to obtain further training in this area.