Forum Discussion
Kudo CommanderPower BI Online return Credential Invalid Error on Anonymous Access of API URL
Hello Vicky_Song and ttinsley
I will consider this case closed.
I had to replace all of our connections to the webservice for connections in a newly created database on Microsoft Azure.
Now we can refresh the dataset normally.
But I think that problem with the refresh using the webservice is linked to the fact that the Power BI Service performs the same call multiple times.
See the image below of my webservice LOG:
We would appreciate it if one day it is resolved.
I am running into a similar problem right now as well. I can see that you were able to solve the issue some month ago. Nevertheless, I am not able to understand what steps I would have to make to connect my datasets.
What do you mean with
I had to replace all of our connections to the webservice for connections in a newly created database on Microsoft Azure.
Could you give me more information how you solved this and how this might relate to my case?
Kind Regards
Kudo CommanderHello Lukas_Sieber,
Our company has a database system in AWS to store ERP data.
Previously we had created a webservice that searched the data in AWS and answered for Power BI.
As Power BI makes endless requests, our AWS database was overloaded.
Based on this we decided to separate the base that responds to the ERP of the base that responds to the Power BI.
We created a database in Azure.
And we set up an ETL to store in Azure (only the data we want to use in BI).
It got a little more expensive, but it was the best decision we made.
Today we have been able to use ERP and Power BI perfectly.
See u later.