Forum Discussion
problem with google sheets connection
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.
Hi, thanks for your reply. I managed to solve it, the problem was that my version of power bi was out of date
4 Replies
Hello GiovanniSilva
are you using Native Google Sheets Connector?
if not try Transition to the Native Google Sheets Connector.
Hi, thanks for your reply. I managed to solve it, the problem was that my version of power bi was out of date
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
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.
