Jayesh Fulsundar

My feedback

  1. 306 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      21 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →
      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  · 
    • 701 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        53 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
        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.

      • 1,258 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          backlog  ·  248 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →
          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.