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.
I live in a country in which a comma (,) is normally used as a decimal separator. E.g. one and a half is 1,5.
I built a pipeline in PowerBi Desktop that imports data from a sharepoint folder and uses it to produce a dashboard. It works great, the only problem is that there's no way to automate the refresh.
So my idea was to build a dataflow to import exactly the same input data from the sharepoint folder and then schedule the refresh of the dataflow. It works ok. The problem is that the numeric data in the dashboard produced this way is completely wrong.
I spent several h trying to figure out why and now I see it: the measures are imported incorrectly. PowerBI Service seems not to read commas. So if I have "23,34" in my input file on the sharepoint, it's imported as "2334" into the dataflow.
I've now tried everything possible to change that. I've tried importing the data as "type text" (to change the type later) but it doesn't help - the result is always "2334". I've also tried changing my language setting in the PowerBI Service into my regional language, instead of English, but it doesn't help either.
Any ideas what to do? The dataflow is useless to me if the numbers aren't correct.
Here's the code:
Solved! Go to Solution.
I've now figured it out. I needed to change helper files.
EDIT: It worked for one file and is not working for the rest.
@BerlinAlexander - This strikes me as a regional language setting issue, perhaps in your tenant settings?
You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
I've now figured it out. I needed to change helper files.
EDIT: It worked for one file and is not working for the rest.
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.