topic Re: problem with google sheets connection in Report Server

problem with google sheets connection

GiovanniSilva — Wed, 29 Jan 2025 21:40:58 GMT

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.

Re: problem with google sheets connection

nilendraFabric — Wed, 29 Jan 2025 22:49:38 GMT

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-native-connector

Re: problem with google sheets connection

GiovanniSilva — Wed, 29 Jan 2025 23:53:45 GMT

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

Re: problem with google sheets connection

Anonymous — Thu, 30 Jan 2025 07:16:23 GMT

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

Re: problem with google sheets connection

rohit1991 — Tue, 08 Jul 2025 12:08:17 GMT

Hi GiovanniSilva ,

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

Solutions:

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