Forum Discussion

TeofiloTamele's avatar
TeofiloTamele
Regular Visitor
2 years ago
Solved

Power BI Export to excel - Keep data type

Hi all, Please Need help. When i export data from PowerBI Service using Export>>Analyse in Excel option creates a pivot table, the issue i am facing is that some columns which stores numbers goes as...
Need Help
  • TeofiloTamele's avatar
    TeofiloTamele
    2 years ago

    Hi all,

     

    I found a work around to this,

     

    I created a measure to output the quantities of that column and i am using it for analysis.

    Thanks

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, TeofiloTamele 

Use the Power BI Excel add-in: If you're not already using the Power BI Excel add-in, consider using the Power BI Excel add-in for a more integrated experience. This add-in allows for a more seamless integration between Power BI datasets and Excel, potentially alleviating data type conversion issues. For more information about this add-in, visit: 

Create Excel workbooks with refreshable Power BI data - Power BI | Microsoft Learn

 

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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

 

  • TeofiloTamele's avatar
    TeofiloTamele
    Regular Visitor
    2 years ago

    Also using the excel add in as explained in the link you shared but getting the same results. Thanks for trying to help. Let me try to bring more context to it.

    The columns is a  decimal number as per below pic:


     Updating Media

    Is used in visuals to provide total sales:

    Using Excel ading or exporting from PowerBI gives same results

    It only accept to be in rows not in values as expected: