API Call via MS PowerBI

Developer Forum
4
  1. Open Power BI Desktop:

• Start Power BI Desktop on your computer.

  1. Open the Power Query Editor:

• Click on the Home tab.

• Select Transform Data to open the Power Query Editor.

  1. Enter the M Script:

• In the Power Query Editor, click on Home > Advanced Editor.

• Delete any existing code and paste your M script into the Advanced Editor.

  1. Adjust the Script (if necessary):

• Replace {yourToken} with your actual API token in the Authorization header.

  1. Run the Script:

• Click Done to close the Advanced Editor.

• Power Query will run the script and fetch data from the API.

• You should see the data loaded into the Power Query Editor.

  1. Load the Data:

• After verifying and transforming the data as needed in the Power Query Editor, click on Close & Load to load the data into Power BI.