Jayesh Fulsundar

My feedback

  1. 473 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    29 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jayesh Fulsundar commented  · 

    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  · 
  2. 2,764 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    365 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    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. 3,864 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    633 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →

    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

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.