topic Re: Saving output to .csv from DQL - different behaviour this week - underlying numerical data not downloaded in DQL

Saving output to .csv from DQL - different behaviour this week - underlying numerical data not downloaded

AlanFoley — Tue, 13 May 2025 06:06:30 GMT

Hi Guys

When downloading DQL output as .csv from a DQL query - As of this week I have noticed that the downloaded data is as per "DQL Output Presentation" instead os the underlying numerial data

For example DiskUsedPercent shows a value of "< 0.01" and DiskUsedBytes "115.28 GB" etc

Previously the underlying "numerical" data was downloaded but now the data downloaded is as per the display in Notebook

See attached screenshots showing data in Notebook and MS Excel

Effectively the downloaded data is unusable in this format

Is there a setting to disable this? - Hoping for a resolution so just the raw data is downloaded

Appreciate the feedback

Regards
Alan

Re: Saving output to .csv from DQL - different behaviour this week - underlying numerical data not downloaded

Philipp_Kastner — Wed, 21 May 2025 10:09:30 GMT

Hi @AlanFoley ,
Thanks for reaching out and reporting this issue. We're already investigating this in order to restore the possibility of getting the raw data as .CSV.

As a workaround you could have a look at the Units and formats settings and overwrite the formatting to export better consumeable data.

Kind regards,
Philipp

Re: Saving output to .csv from DQL - different behaviour this week - underlying numerical data not downloaded

AlanFoley — Tue, 27 May 2025 07:01:40 GMT

Hi Philipp

Apprecaite the reply

Yes I am using the Units and formats to do the override

Previously the default was no override reuired now you have to explicitly override each column - this is rather time consuming

Previous default was better

Regards

Alan

Re: Saving output to .csv from DQL - different behaviour this week - underlying numerical data not downloaded

AlanFoley — Thu, 10 Jul 2025 07:18:42 GMT

Looks like the download functionality has been enhanced and planned for SaaS 1.319 🙂