Adding Broker API in Power BI
Here's a general outline of the steps you can follow:
Get API Access: Ensure you have access to your broker's API and the necessary authentication credentials (API key, secret, token, etc.).
Open Power BI: Launch Power BI on your computer.
Choose Data Source: Click on "Get Data" in the Home tab to choose your data source.
Select Web or JSON: Depending on your broker's API, you can select either the "Web" option or the "JSON" option as your data source.
Enter API Endpoint: Enter the API endpoint URL provided by your broker in the "URL" field. This URL is where you'll be making API requests to fetch the live feed data.
Configure Authentication: Depending on the authentication method your broker uses (e.g., API key, OAuth), you may need to configure authentication settings. If it's API key-based, you can often include the API key in the URL itself or provide it in headers. If it's OAuth, you might need to enter the appropriate credentials.
Transform Data (Optional): Power BI might load the data as-is or allow you to transform it. You can use the Power Query Editor to clean, filter, or modify the data before using it in your reports.
Load Data: After configuring authentication and optionally transforming the data, click on the "Load" button to load the live feed data into Power BI.
Create Visualizations: Once the data is loaded, you can create visualizations like charts, tables, and graphs using the "Visualizations" pane.
Set Refresh Schedule: If you want the data to update automatically, you can set a refresh schedule in Power BI. Depending on your version of Power BI, there might be limitations on how often you can refresh data in the free version.
Save and Publish: After creating your visualizations and setting up refresh, you can save your Power BI file and publish it to Power BI Service if you want to share it with others.
