Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
totoalbin
Helper I
Helper I

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:

 

Screen Shot 2018-10-23 at 7.06.06 AM.png

I tried downloading the Personal Gateway and it still shows this.

 

Thank you very much

6 REPLIES 6
v-yuezhe-msft
Employee
Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-yuezhe-msft

 

It doesn't have an Anonymous authentication method I am afraid 😞

 

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

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello @v-yuezhe-msft, yes I only have OAuth2 method.

Hello @v-yuezhe-msft,

 

I apologize for not replying sooner here is the code:

 

let
    Source = PQGoogleSpreadsheet.Contents("https://docs.google.com/spreadsheets/d/14O1CaEDMJVNFZirrl3JjiBJo2WAtBRTV-zRrtxEh60I/edit?usp=sharing"),
    #"Deep Thought_Sheet" = Source{[Item="Deep Thought",Kind="Sheet"]}[Data],
    #"Removed Top Rows" = Table.Skip(#"Deep Thought_Sheet",1),
    #"Promoted Headers" = Table.PromoteHeaders(#"Removed Top Rows", [PromoteAllScalars=true]),
    #"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"Date Added", type date}, {"Date Added (On Quip)", type date}, {"Card Address", type text}, {"Site Finder / Card Creator", type text}, {"Deep Thought Analyzer", type text}, {"Trello Board", type text}, {"Approach Ready Date", type date}, {"Approach Sent Date", type any}, {"09/01/2019 10:46:19 AM", type any}, {"Offer Sent Date", type date}, {"How We Found Contact?", type text}, {"Notes From Yafit", type text}, {"Notes To Yafit", type text}, {"Letter Responded", type text}, {"Response Received Date", type date}, {"Response By", type text}, {"Time Taken For Response", type any}, {"Deal Status (To Be Filled By UK Team)", type text}, {"Not Good Site (Reason)", type text}, {"Letter Sender Name", type text}, {"Approach/ Offer?", type text}, {"Reason For Returned Letter", type text}, {"Alternative Ready Date", type text}, {"Alternative Letter Sent Date", type text}, {"Remarks", type text}, {"Can't Find Owner", type text}, {"Site Rating", type any}, {"Card Email", type text}, {"Reference Number", type text}, {"Postcode", type text}, {"Name Of Council", type text}, {"Owner Name 1", type any}, {"Owner Name 2", type any}, {"Last paid price", type any}, {"% the market changed from sold date", type any}, {"Zoopla % Changed", type any}, {"Existing price Total", type any}, {"Houses / Flats / Only BGD/ Commercial ?", type text}, {"Strategy ", type text}, {"Is It BGD? [Yes/No]", type text}, {"Average Price (Flats)", type any}, {"Average Price (Houses)", type any}, {"What Value Did We Use? [Please specify the way to calculate the existing value]", type text}, {"Footprint [All units]", type any}, {"Number of houses", type text}, {"Number of flats", type text}, {"Underground parking [Yes/No]", type text}, {"Conversion of existing? [Yes/No]", type text}, {"Build cost.", type any}, {"Total Purchase Price", type any}, {"Toal SDLT", type any}, {"Total CIL", type any}, {"Total Affordable Housing", type any}, {"Legal Charge", type any}, {"Estate Agent Fees (For Resale)", type any}, {"Marketing", type any}, {"Finance", type any}, {"Planning, Inc professionals", type any}, {"Contingency", type any}, {"Demolition of Existing", type text}, {"Profesional & Development Costs", type any}, {"Total Building Expenses", type any}, {"Total Profit", type any}, {"Resale Value Flats", type any}, {"Resale Value Houses", type any}, {"Total Resale Value", type any}, {"Expenses Grand Total.", type any}, {"GDV Grand Total", type any}, {"Profit on GDV", type any}, {"Site Value", type any}, {"Existing Land Value", type any}, {"Our Site Projected Offer", type any}, {"% Of Site Value", type text}, {"% added from site rating program", type text}, {"PTAL Rating", type any}, {"Flood Zone", type any}, {"TPO On Site", type text}, {"Approach Letter Sender Name", type text}, {"Offer Letter Sender Name", type text}, {"X", type text}, {"Y", type text}, {"Property Address", type text}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type1", each [Date Added] <> null and [Date Added] <> "")
in
    #"Filtered Rows"

I only have OAuth2 method.

 

 

Thank you very much

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

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors