Connection to Azure Insign using WebApi key

[Dawid_PH]

Hi, I have problem with connection to AzureInsight using Web API key authorization.

I create key in AI:

When I try send request using rest client, this working fine, using get and post:

But when try do this in PowerBI:

When I try connect using my credential (e-mail + password) all woroking fine.

I know I can do some workaround, and first save this in SQL, then get to reports, but I'd like know why I can't authenticate.

I using PowerBI desktop app.

[Dawid_PH]

In fact, it was a bit related to the permissions, because it turned out that I can't connect to SQL either, but I got the permissions, and then I can't connect to AzureInsight, so far I get the data in a different way.

[v-luwang-msft]

Hi @Dawid_PH ,

This maybe a permission/authentication error. When you ever connect to  your data source in an unauthorized account, the corresponding credential would be created. You may need to change credential,  go to “File –> Options and Settings –> Data Source Settings”, under “Global permissions”, select old SQL Server data source connections and click on Edit permission in Power BI Desktop, then connect to it and check if it is successful.

refer:

https://community.powerbi.com/t5/Desktop/We-couldn-t-authenticate-with-the-credentials-provided-Plea... 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien