Jayesh Fulsundar
My feedback
-
428 votesJayesh Fulsundar
supported this idea
·
-
928 votes
Thanks for the suggestions! I’ve split out the other cloud storage options into separate ideas for people to vote on.
Jayesh Fulsundar
commented
I have managed to get good response by using following blank query. = Excel.Workbook(Web.Contents("https://docs.google.com/spreadsheets/d/hiddenhiddenhidden3fGh4m6kd2N_hidden0/export?output=csv"), null, true)
However it works only with personal google sheet, and not organisational google account such as xyx@yourname.com (which is hosted by google)
I am having following problems, in-spite of above workaround to get Google sheet in Power BI.
1. It pops up various error messages, and stops refreshes from google sheet.
2. It sometimes adds "null"/blank rows, above data, pushing actual data to the bottom of table.
3 Considering #1 & #2, whole scenario becomes very unreliable to deploy reporting mechanism in our organisation.Would be glad if MS provides an easy solution to overcome all such problems.
-
2,856 votesJayesh Fulsundar
commented
Yes this feature will help many users/developers/analyst like me
I found solution to this problem
Just select the column that is having binary data in query editer and click right >> transform >> text and it is done. click close and apply you will be able to see the column with appropriate text, which otherwise was not available to see in table view.