Forum Discussion

totoalbin's avatar
totoalbin
Helper I
7 years ago

Failed to update data source credentials: 0 arguments were passed to a function which expects 1

Hello,   I made a custom Google Sheet to PowerBI connector from the internet.  It worked out well.  Now the only thing missing is the autorefresh capability.   The error shows like this:   ...
General Comment
Anonymous's avatar
Anonymous
Not applicable
7 years ago

totoalbin,

Are you able to use Anonymous authentication method in Power BI Service to refresh the dataset? There is a similar thread for your reference.

Besides, can you successfully refresh data in Power BI Desktop?

Regards,
Lydia

  • totoalbin's avatar
    totoalbin
    Helper I
    7 years ago

    Thank you very much will try this out and report back.

  • totoalbin's avatar
    totoalbin
    Helper I
    7 years ago

    Anonymous

     

    It doesn't have an Anonymous authentication method I am afraid :-(

     

    I can successfully refresh the data in the PowerBI Desktop though.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      totoalbin,

      Could you please post the Power query code you use in Power BI Desktop? Do you only have OAuth2 method in Power BI Service?

      Regards,
      Lydia

      • totoalbin's avatar
        totoalbin
        Helper I
        7 years ago

        Hello Anonymous, yes I only have OAuth2 method.