Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
@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
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.
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
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
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.
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
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 -
Try inserting single quote ' before the value(s) that Excel is treating as Percentage.
Proud to be a Super User!
Hi Chris,
I have huge no data like 800 rows can you please tell me any other alternative solution
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |