The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Just installed June release of Desktop. Connected to data source via analysis services. When exporting a table that has both positive and negative whole numbers, the exported CSV file is treating the negative whole numbers as text. (e.g -2 is exported as '-2). This then creates a column of mixed numeric and text numbers. Not helpful when you're using the extract for other things. Uninstalled June, reinstalled May, and the problem went away.
Solved! Go to Solution.
@Anonymous Could you please repost this in the Issues forum here and include as much info as possible, including the specific version you have (there have been at least 3 June versions as they incrementally update after a major release) and the column type format in SSAS for the column you are having an issue? Integer, currency, number, etc.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi @Anonymous
If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!
Hi @Anonymous
If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!
@Anonymous Could you please repost this in the Issues forum here and include as much info as possible, including the specific version you have (there have been at least 3 June versions as they incrementally update after a major release) and the column type format in SSAS for the column you are having an issue? Integer, currency, number, etc.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingUser | Count |
---|---|
83 | |
83 | |
37 | |
34 | |
32 |
User | Count |
---|---|
92 | |
79 | |
62 | |
53 | |
51 |