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.Jayesh Fulsundar supported this idea ·
Thanks for the suggestions! I’ve split out the other cloud storage options into separate ideas for people to vote on.
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 email@example.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.
Yes this feature will help many users/developers/analyst like me