Forum Discussion

roncruiser's avatar
roncruiser
Post Patron
4 years ago

Analyze in Excel Changes Data Types

I publish a dataset from Excel using Publish to Power BI -> Export. When I access the Dataset from the Power Bi service utilizing Analyze in Excel, the number data types are changed from whole num...
Need Help
Show and Tell
roncruiser's avatar
roncruiser
Post Patron
4 years ago

HenriqueReis 

I've not tried that yet.

What I'm trying to do is publich data from Excel to Power BI using the Export workbook data to Power BI feature in Excel.  


Re-accessing that same Dataset in the Power BI service using Excel and the datatypes are different.



Re-accessing the Dataset using Analyze in Excel is easier for some of my colleagues but the change of Data Type is frustrating to get around.

Is there a setting in Excel to change I am unaware of I just cannot find?

Thanks!