Forum Discussion

ThalesFerraz's avatar
ThalesFerraz
Icon for Kudo Commander rankKudo Commander
10 years ago
Solved

Power BI Online return Credential Invalid Error on Anonymous Access of API URL

I can refresh the dataset normally by Power BI Desktop. Using this (example):   [ Spoiler ] But I can't refresh the dataset in Power BI Online because it is returning the error below:     ...
Need Help
  • ThalesFerraz's avatar
    ThalesFerraz
    10 years ago

    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.

ThalesFerraz's avatar
ThalesFerraz
Icon for Kudo Commander rankKudo Commander
10 years ago

Hello there,

Hello Power BI Team,

 

I posted this need a long time and the error persists.

 

I need help.


Power BI don't have a solution for this?

Vicky_Song's avatar
Vicky_Song
Icon for Impactful Individual rankImpactful Individual
10 years ago

ThalesFerraz, how about your first deleting all datasets in the Power BI Service and then republishing datasets and reports to the Service? I ever faced the same issue as yours. And my issue ended as resolved via that step. However, you need to be note that, your may need to recreate Power BI Dashboard after you publish the new dataset. 

  • ThalesFerraz's avatar
    ThalesFerraz
    Icon for Kudo Commander rankKudo Commander
    10 years ago

    Hi Vicky_Song,

     

    Thx for asking

     

    - I've tried after deleting the dataset and transmit again.

    - I've tried after transmitting the dataset with a different name.

    - I've tried after transmitting to a shared workgroup and to a personal workgroup.

    - I've tried after transmitting using a machine that has the gateway installed and another machine without the gateway installed.

    - I've tried after redoing the dataset from zero based.

    - I've tried updating the dataset using a local URL (restfull) and using a web URL.

    - I've tried updating the dataset using a Pro account and using Free account.

     

    Nothing works

    • Vicky_Song's avatar
      Vicky_Song
      Icon for Impactful Individual rankImpactful Individual
      10 years ago

      ThalesFerraz, your issue is quite strange for me. I will try to invite other senior engineers.

      • ThalesFerraz's avatar
        ThalesFerraz
        Icon for Kudo Commander rankKudo Commander
        10 years ago

        thx Vicky_Song, i i'll wait.


        I take this message to ask a detail.
        How does the request process on Power BI Service?

         

        I ask because the Bi Power Service returning Timeout error.
        The problem may be in how the data are requested.

         

        See the image below.

         

         

         

        In case 1, we would not have any problems because if the error occurs in a specific request is only reduce the query period or increase the time for timeout.

         

        But in case 2, if there is a timeout for the entire group of requests I would have to do.