problem with google sheets connection

[GiovanniSilva]

Hello, I am facing a problem regarding the "google sheets" connection, when clicking on "get data" the connection with google sheets that previously appeared, is now no longer appearing.

[rohit1991]

Hi @GiovanniSilva ,

This error occurs when Power Query loses the function reference after exporting to .PBIT.

Solutions:

1. Revalidate PriorVisitIEN in Power Query.
2. Reapply "Invoke Custom Function" manually.
3. Ensure function is defined before usage in applied steps.
4. Use explicit reference: = Table.AddColumn(#"Changed Type", "Prior Visit", each @PriorVisitIEN([EPI], [IEN]))
5. Check parameter types match the function's expected input.

"The goal is to turn data into information, and information into insight." – Carly Fiorina

Need Power BI help? Connect on LinkedIn.

[nilendraFabric]

Hello @GiovanniSilva 

are you using  Native Google Sheets Connector?

if not try Transition to the Native Google Sheets Connector.

https://accessorange.com/en-hk/fixing-google-sheets-and-power-bi-dataflows-the-transition-to-the-nat...

[GiovanniSilva · Accepted solution]

Hi, thanks for your reply. I managed to solve it, the problem was that my version of power bi was out of date

[Anonymous]

Hi @GiovanniSilva 

Glad to hear you solved the problem yourself! Could you please mark your answer as Solution? This will help more users who are facing the same or similar difficulties. Thank you!

Best Regards,
Yulia Xu