Doesn't Support Refresh Help

[seanpratt]

Good morning,

I've searched through these forums for similar problems and solutions and while I found some, I can't fully understand how to adapt the solution to my situation. 

I have a Google Sheet data source that works fine within Power BI Desktop but seems to block the data refresh within Service. I get the "Query contains unsupported function. Function name: Web.Contents" error.

Can someone please check out my M source code below and make some real suggestions on how to correct this issue? Please do not link me to another post within this forum (drives me nuts).

Thank you in advance for any suggestions or help 🙂

let
Source = Excel.Workbook(Web.Contents("SPREADSHEET NAME"), null, true),
#"Expanded Data" = Table.ExpandTableColumn(Source, "Data", {"Column1"}, {"Column1"}),

[v-xicai]

Hi  @seanpratt  ,

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai]

Hi @seanpratt ,

Currently, you can connect to Google Sheets using Web connector, see more detail steps: Using Google Sheets as a data source in Power BI.

The generated power query could be like codes below, so you may correct your query codes follow steps in above link.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi there

Currently Google Sheets is not supported in Power BI as a native connector.

The only current option is to create a custom connector.