Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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:
I tried downloading the Personal Gateway and it still shows this.
Thank you very much
@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
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
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
29 | |
12 | |
12 | |
11 | |
8 |
User | Count |
---|---|
53 | |
28 | |
15 | |
14 | |
13 |