Prevent Power Query from returning all datasets used in Python script

[Anonymous]

I'm using a Python script to perform some transformations to a dataset, but I realized the script returns a list of all dataframes used in the process.

I already tried deleting the dataframes using the del statement in Python, but Power Query keeps returning all dataframes.

# Clean memory
lst = [dataset, inbound, merged, outbound, voicemail]
del lst

Is there a way to tell Power Query to return only a single dataframe?

Thanks in advance!

[Faisal97]

I want to make numbers like in excel with comma. But, It's convert it to whole number automatically in power bi. Is anyone can help me with that. 

[adudani]

@Faisal97 ,

in the power query editor, if you change the column data type to "Decimal Number(1.2)"
by left clicking on the existing whole number type and choosing decimal, do you get errors?

[Faisal97]

thank you for your response. Yes when I change it to decimal numer 1.2 I got an error

[adudani]

I think It's because of the multiple periods(.) 

To test it, split the column by delimeter right most delimeter .

If this resolves the error let me know.

It will then depend on the accuracy required.

I suggest formatting in such a way that you have only one "." In the number for decimal places.

[Faisal97]

Still not working with Delimiter option, but I'll find a way to solve it thanks.

[adudani]

hi @Anonymous,

you could click on down arrow in the Name column, 

and use any of the functions ( Name contains, starts with etc.)
this will return the records of selected dataframes.

let me know if this works for you.