Question: how to import data from api in power bi?
Answer: Open Power BI Desktop and on the Home tab, select Get data and choose the Web option. Paste your metric query's URL into the Power BI dialog asking for the Web page URL. In the Access web content dialog, select Basic, enter your app's API key as the Username, and press Connect.