Thank you very much! I add that if initial format of the file is .xlsx (excel) and the connection doesn't works, you can change the format to Google sheets to make it works
Hello , thanks very much for your video. However, I still face with this error, do you know why and how to fix it? DataSource.Error: Unable to parse range: Details: errorstatus=INVALID_ARGUMENT errormessage=Unable to parse range: errorcode=400
hi sir , firstly i would like to thank for ur great effort on producing this juicy vdo , but could u help me out with connecting to google sheet .. I hardly see it when browsing on the blog u have mentioned.. looking forward to hearing back. Thanks
Hi You can schedule refresh a Power BI report no matter where the source is coming from. If the source is supported in Power BI report server, then certainly you can schedule it to refresh.
Hi There, I have developed a report in Power BI desktop using various DAX formulas and calculations, report has two or more pages, the report is in table format only. users are accessing this report online Now I am looking for a solution (formula / VBA or any other trick) by which I can create an export to excel button which will extract two or more pages from the Power BI desktop & online both services and save them in a single excel workbook. Please guide me to perform this activity.
Hi Reza, I tried to download Power BI Helper on multiple occasions but no luck from last 3 month ..i tried different browsers , different laptop and mobile devices ..seems there is issue in link sending ..I haven't received any mail ..could u pls help. ..TIA
@@conleyyang4318 yes it works ! just go to Power Bi service, then go to your specifi datasets , choose setting and sign in your credentials, after that just click refresh (datasets)
@@zerrahleemariano313 Thank you for replying back! Somehow it doesn't work for me. Does it require a more recent version of the gateway? I was able to sign in with Organizational access but the dataset failed to refresh.
to be precise, it failed when the google sheet data source is merged into another data source to produce a new table, for my case its merged to a ODBC. The error message i got is {"error":{"code":"DM_GWPipeline_Gateway_InvalidMashupConnectionString","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidMashupConnectionString","parameters":{},"details":[],"exceptionCulprit":1}}} Table: Query1.
![[TF2] The Russian Bear Trap](http://i.ytimg.com/vi/YFNSwz2_rOA/mqdefault.jpg)
Thank you Sir!!!!
3:20 setting credentials to PBI services
3:38 setting your credentials "GoogleSheets" in PBI services
Thank you very much! I add that if initial format of the file is .xlsx (excel) and the connection doesn't works, you can change the format to Google sheets to make it works
Thanks! Exactly this was happening to me
help!! plss.. i do the same but its always time ouut, anysolution plss?????
Same problem here
Wow! You just updated this video at the time right..!! Great..thanks 😀
Hello , thanks very much for your video. However, I still face with this error, do you know why and how to fix it?
DataSource.Error: Unable to parse range:
Details:
errorstatus=INVALID_ARGUMENT
errormessage=Unable to parse range:
errorcode=400
Wow, Thanks !! Now I can analyze folios on my desktop.
Glad I could help!
Finally! This was so needed
Nice Information
hi sir , firstly i would like to thank for ur great effort on producing this juicy vdo , but could u help me out with connecting to google sheet .. I hardly see it when browsing on the blog u have mentioned.. looking forward to hearing back. Thanks
Hello sir.How to connect Google Sheets to Power BI using the Importange function.
hello, i use power bi report server, when i used google sheet connector , my power bi report server does not detect my source
HI i dont see the 3rd option as Google sheet in my tool. i can see only the google bigquery and analytics
Thank you, really helpful !
hi, thank you..PLZ... is it possible to set schedule refresh in power bi report server for Google sheets???
Hi
You can schedule refresh a Power BI report no matter where the source is coming from. If the source is supported in Power BI report server, then certainly you can schedule it to refresh.
awesome thank you for this!
Is getting the data from a database into GSheets or Excel a use case? anyone facing this workflow?
Thanks Reza, i remember that Power BI can get data from Google sheet by Publish to the Web. Your this way have what advantage better?
ff
Hi There,
I have developed a report in Power BI desktop using various DAX formulas and calculations, report has two or more pages, the report is in table format only. users are accessing this report online
Now I am looking for a solution (formula / VBA or any other trick) by which I can create an export to excel button which will extract two or more pages from the Power BI desktop & online both services and save them in a single excel workbook.
Please guide me to perform this activity.
Thank U
Can power BI connect to my 10 google sheets ???
Hi Reza, I tried to download Power BI Helper on multiple occasions but no luck from last 3 month ..i tried different browsers , different laptop and mobile devices ..seems there is issue in link sending ..I haven't received any mail ..could u pls help. ..TIA
Please use the contact us page on our website
why when i try this its too long.... cant connected "waiting for doc.google.."?? anyone can help??
Same problem here
0:15 obrigado por tudo autoridade social graças a voces as minhas redes estao voando alto
if i refresh this in desktop, will it also refresh in power bi service?
Did you figure out if it works on the service?
@@conleyyang4318 yes it works ! just go to Power Bi service, then go to your specifi datasets , choose setting and sign in your credentials, after that just click refresh (datasets)
@@zerrahleemariano313 Thank you for replying back! Somehow it doesn't work for me. Does it require a more recent version of the gateway? I was able to sign in with Organizational access but the dataset failed to refresh.
to be precise, it failed when the google sheet data source is merged into another data source to produce a new table, for my case its merged to a ODBC. The error message i got is
{"error":{"code":"DM_GWPipeline_Gateway_InvalidMashupConnectionString","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidMashupConnectionString","parameters":{},"details":[],"exceptionCulprit":1}}} Table: Query1.