how can i import data from excel to powerbi without any change

[Anonymous]

Hi All,

In same colums has differnt Data like Text,Numbers,% etc.. When ever i import Data 85% becoming 0.85 .

i want to import data without any change through import option,so that i can refresh in future

Thanks in Advance

[heryox]

Hi, you have 2 solutions: or format like text Excel file or chance format in power query like %. The better way is the power query because if in a second time you change file you need to format again the Excel column. With power query he memorize the transformation and you do this only one time

If this post help you mark this like solution

Thank you

[Anonymous]

@heryoxcan you please share some screen shots or PBIX file if Possible, I have Tried it but no luck.

Thank you.

Best Wishes,

Younis Syed

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You can use TEXT() function in the Excel. 

When you import it at first time, you need to remove other columns with wrong format in the query editor. 

When you refresh next time, the new data will be displayed directly.

Best Regards,

Eads

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

[Anonymous]

If you plan to connect an Excel file as your datasource, I would suggest taking the time to format the columns in the Power Query Editor. Any change you make here will be documented and saved.

The next time you wish to add new data to the Excel sheet and refresh the data, you have two options:

1) Simply overwrite the saved Excel sheet with the new Excel sheet, Power BI will automatically input the new information with the same column formatting

2) You can save a new Excel file and change the data source settings of the report in Power Query Editor each time you create a new Excel file. The column formatting will still be maintained

Hope this helps!

[Anonymous]

@Anonymous  

can you please share some screen shots or PBIX file if Possible, I have Tried it but no luck.

Thank you.

Best Wishes,

Younis Syed

[Anonymous]

Hi Zdietrich,

Please find below data which i want to load without any changes:

Target	Actual
90%	75%
90%	NA
90%	98%
95%	NA
2 Days	6 Days
Count	331
$ Value in mn	1.52
5 Days	5 Days
98%	100%
0	0

  After Loading in Power BI it is becoming :

98% --> 0.98 ,when i changing Data type in Power Query Other than percent values giving error,

I want load data without any change through GET Data -->Excel -->Power Bi.

Thanks In advance.

[Anonymous]

When you load data from Excel into PowerBI, it auto-formats based on its detection of the data in each column. This part of PowerBI feature. To undo that, open up Edit Queries, then cross the last step in the Query Editor -> Change Type

[Anonymous]

can you please share some screen shots or PBIX file if Possible, I have Tried it but no luck. Thank you. Best Wishes, Younis Syed

[ChrisMendoza]

@Anonymous -

Try inserting single quote ' before the value(s) that Excel is treating as Percentage.

[Anonymous]

Hi Chris,

I have huge no data like 800 rows can you please tell me any other alternative solution