Forum Discussion

Surekha_PM's avatar
Surekha_PM
Resolver I
2 years ago
Solved

How to download Graph data with same Header name

Hello Everyone,

I am trying to export the graph data as table but it is not showing the table header as per the calculated measure and not as per the graph header name. I could see the "Data with current layout" option, but it is not enabled. Can anyone please help me with any suggestions?



Regards,
Surekha

Need Help
  • Surekha_PM's avatar
    Surekha_PM
    2 years ago

    Hi Anonymous ,

    Thank you for help. For now, I have made the changes in the column name in the Power BI desktop itself. So, this issue is resolved now. 

    Regards,
    Surekha Prasad

12 Replies

  • Surekha_PM's avatar
    Surekha_PM
    Resolver I
    2 years ago

    Hi Anonymous ,

    Thank you for help. For now, I have made the changes in the column name in the Power BI desktop itself. So, this issue is resolved now. 

    Regards,
    Surekha Prasad

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Surekha_PM ,

    Regarding your question, you need the column names of the exported data to be the same as the field names in the visualization, right?

    Like this?

    Please use .csv file format.

    The "Use data from current layout" option automatically exports totals for table visuals or matrix visuals.


     

    Best Regards,
    Wenbin Zhou
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Surekha_PM's avatar
      Surekha_PM
      Resolver I
      2 years ago

      HI Anonymous 

      Thanks for your help. This works. But client might select the xlsx format while downloading the file. Is there any way to give only one option of csv to downlaod the file.

      Regards,
      Surekha

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Surekha_PM ,

        You can disable this option by contacting your administrator.


        Best Regards,
        Wenbin Zhou
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Surekha_PM's avatar
    Surekha_PM
    Resolver I
    2 years ago

    Hi Anonymous ,

    Firstly, thank you so much for your continuous reply to all my queires. Truly appreciated! Secondly, I made the changes that you suggested. Even after doing so, I don't see the option that is showing on your end.

    Changes made in PowerBI Desktop:

    Even after this, the report header is still same. It shows the database name in it. 

    What am I missing on my end?

    Regards,
    Surekha

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Surekha_PM,

      Sorry for only seeing your reply now, can you show me what it looks like in Power BI Service?