Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have created an table in Power BI, connected to an Power Automate button that's create an excel-table on sharepoint.
The majority of the data exports correctly, but the number values seems to differ betwen the rows, and it seems to be the ones with many decimals.
I have tried to change all the data to correct format (currency), but it doesent help. Do you guys have an idea of the problem?
Desktop:
Power Automate flow:
Sorry for the Swedish naming in the flow. If you need the english translation please say 🙂
Hi @v-tianyich-msft and thanks for answer.
The weird part of this is that some rows is correct, and some dont. Se the imput data och exported data below:
Input:
You can se it even changes the format to text in some rows 😮
Hi @boullen ,
During my investigation I have found users in the past who have had similar experiences to you .
The solution given by other forum users was:This may be caused by the regional settings you use, in which the decimal operator is most probably the comma, as opposed to the dot character.
For original post, you may refer to:Solved: Importing decimal numbers on Excel - Power Platform Community (microsoft.com)
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
81 | |
65 | |
65 | |
60 |
User | Count |
---|---|
170 | |
114 | |
102 | |
73 | |
69 |