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

Question

Hello,&nbsp;I made a custom Google Sheet to PowerBI connector from the internet.&nbsp; It worked out well.&nbsp; Now the only thing missing is the autorefresh capability.&nbsp;The error shows like this:&nbsp;I tried downloading the Personal Gateway and it still shows this.&nbsp;Thank you very much

anonymous · Answer

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,&nbsp;can you&nbsp;successfully refresh data in Power BI Desktop?Regards,Lydia

totoalbin · Answer

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

totoalbin · Answer

Anonymous&nbsp;It doesn't have an Anonymous authentication method I am afraid :-(&nbsp;I can successfully refresh the data in the PowerBI Desktop though.

anonymous · Answer

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 · Answer

Hello Anonymous, yes I only have OAuth2 method.

Forum Discussion

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

6 Replies

Related content

Destruction of credentials

Table.Sort, unexplainable behaviour with a two-argument function

Send Argument

Custom function Expression Error: 1 argument passsed which expects 2 arguments.

Argument '3' in if function is required