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.
The goal is to have clients export data from a table reflected as is published. The current field in question reflects a list of districts with a comma as a delimiter. While published, data is accurately displayed. When exported, the data will correctly show up to 5 comma places. Any numbers after 5 comma places, will reflect 000. I tried playing with the formatting with in the CSV file but the output is still not correct. Any thoughts on how to have data exported correctly? Below you will find the current output + expected output. The column in question (Assigned_Districts) is reflected as a Text field. This was done in PQ Any advice is greatly appreciated.
Current Output: Notice the last 2 rows with 000
Assigned_Districts |
730,732 |
454,740,819 |
249,250,253 |
685,687,689,698,699,000 |
201,204,205,206,207,000,000,000,000,000,000 |
Expected Output: All of the data is correctly displayed
Assigned_Districts |
730,732 |
454,740,819 |
249,250,253 |
685,687,689,698,699,700 |
201,204,205,206,207,835,208,209,210,215,216 |
Solved! Go to Solution.
I was able to find a solution by changing the delimiter character from comma ( , ) to slash ( / ). This displayed the districts without any interruption. My guess is that since the numbers were 3 digits and separated by comma, the system was interpreting that as a very large number.
I was able to find a solution by changing the delimiter character from comma ( , ) to slash ( / ). This displayed the districts without any interruption. My guess is that since the numbers were 3 digits and separated by comma, the system was interpreting that as a very large number.
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 |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |