Forum Discussion
Solved
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
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.