Jayesh Fulsundar
My feedback
-
473 votes
An error occurred while saving the comment Jayesh Fulsundar
supported this idea
·
-
2,764 votes
Thanks for the suggestions! I’ve split out the other cloud storage options into separate ideas for people to vote on.
An error occurred while saving the comment 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.
-
3,864 votes
Thanks for your feedback on this issue – while we’d like to enable this, there is currently no timetable around doing so. There is the option as a workaround the create a paginated view as a drillthrough of the visual and have a formatted version you can export to Excel, but understand this isn’t a solution everyone can take advantage of currently.
An error occurred while saving the comment Jayesh 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.