When i switched the authentication method in power bi to organizational account and used my google credentials to authenticate, it worked, even though the google sheet. If you are attempting to transfer data from one sheet (tab) to another within the same spreadsheet file, do not use importrange (). I have seen few so posts that show the method to export the whole.
I was wondering if its possible to download say only sheet 1 of a google spreadsheet as excel? It uses a power bi url as a redirect url. It seems you create a connection between google sheets to excel 365 with power query and when you use select get data> from other sources > from web feature and.
You'll be prompted for a google sheets url. Basically, you copy the url for sharing, and then set up a. Now my issue is that i need to have that google sheet set to restricted access only. The google sheets connector supports.
Copy and paste the url from your browser address bar into the input prompt. I had my source sheet saved as an excel format (ie extension.xlsx) and had this permission issue. My question is, is there another way to connect a restricted google sheet (in which i have. An important note before we get into the #ref error: