Google sheets to Power BI: New connector & schedule refresh

[@BhartiPal-jn1tc]

Thank a lot from bottom of my heart ❤❤ i am searching this features from last 1 month but found right way to do this only in your video ❤❤❤❤❤❤❤❤❤❤

[@learnspreadsheets]

I’m glad it helped! Yay

[@theeirv]

If you transfer the google sheet to a shared drive will the power bi still connect, if not, how do you connect the model to the new share drive file/location?

[@learnspreadsheets]

Hi! Yes it should still work, you need to go into power query, then the source step, click the Cpg and change it to the new url

[@juanodonnell]

how do I filter for hidden sheets before expanding the tables?

[@learnspreadsheets]

That is power query steps, the sheet names should come up with a column to say if it’s hidden or not

[@AmmarGasim]

Are you able to edit data from BI and sync to G.sheets?

[@learnspreadsheets]

No it works one way not both

[@learnspreadsheets]

Good question though!

[@HoomanNemati]

hi what about powerbi report server? there is no credential option in there and I cant refresh my report

[@learnspreadsheets]

Hi sorry I am not sure about report server

[@Noone-1980]

Thank you for the vide. How can we make a "LIVE UPDATE". So when the Googlesheet changes, the Power BI form changes also (without hitting refresh). Live update?

[@learnspreadsheets]

Good question. You can set up auto refresh at certain points in the day but live feed I don’t think is possible with g sheets currently (or most sources)

[@sikkansingh54]

Hey David, can we use incremental refresh in google sheets?

[@learnspreadsheets]

Hi I’m not sure about this sorry

[@Bruno-pq6yk]

what about a csv file in google drive? can you explain?

[@learnspreadsheets]

Hey, thanks for the question. There is no google drive connector at this stage, for that you would need to sync google drive to your local computer then get data from folder but you’d need a gateway to refresh it.

[@natalialacerda1517]

I dont have this option.. connect to google sheets.. is there another way?

[@learnspreadsheets]

Hey! Make sure you are on the latest version of power bi (from December 2021) & it should work ok

[@violacambie7279]

Hey David! Thanks for the video! I'm having troubles with the "published" report web link since is not refreshing.. Looks like the dataset and the report are working correctly but the web link doesn't updates. Any idea?

[@learnspreadsheets]

Hi there was a bug with this when it was first released, but I think it was fixed. If it doesn’t work you should get email notifications, send Microsoft a frown & tell them if it continues

[@AbdullahAlMamun-jm4qm]

I have a ques In Current Value option which link is Copied ?? can anyone help me please !

[@learnspreadsheets]

Thanks for the comment but I cannot help I’m not sure sorry

[@AbdullahAlMamun-jm4qm]

@@learnspreadsheets My Ques is - In video 4:23 - (what is that link and from where i found that link which one is pasted that Current Value Option)

[@Rahul-bg8pc]

for me it showing refresh, and it is disabled

[@learnspreadsheets]

Sorry to hear, there are various reasons why that might be but if you write in the forums with demo file uploads people can help hopefully

[@JahidhasanSiyam-i1t]

hallo sir.How to connect Google Sheets to Power BI using the Importange function.

[@learnspreadsheets]

I’ve not tried that but assume it should work as usual. If it doesn’t work as normal then I’m not sure sorry

[@GeorgeGoncharovMath]

Thank you

[@learnspreadsheets]

Yay

[@zulhishamhashim7505]

i can't connect with new google sheet. anyone else face same problem?

[@learnspreadsheets]

Sorry to hear it should still work the same way now

[@hanhdinhhong-vietnam-7799]

Thanks so much, however, I still can't connect to ggsheet with below error, does anyone know how to fix it? DataSource.Error: Unable to parse range: Details: errorstatus=INVALID_ARGUMENT errormessage=Unable to parse range: errorcode=400

[@learnspreadsheets]

Im glad you like the video. Sorry but I haven’t encountered that error