Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a dataset I have imported into a report called new array:
If you actually go to 'transform data' and look at new array you will see it looks like this:
The dataframe has over 40000 rows. Yet if you look at the first screenshot, which has includes a python visualization where the code produces an exception that details the length of the dataset it suggests that it only has 8073 rows. The data has somehow not been imported into python properly. As a further example, I have now designed the python code to produce an exception and display what column 2 of newarray looks like according to python:
As you can see the values it has produced look nothing like the correct values from column 2 of new array that is seen in 'transform data' (look at column 2 in the second screen shot). What values do appear, seem to be a subset of the values from column 2 and an in ascending order.
Can someone tell me why the data in python (within python visualization) is not imported directly as it looks in 'transform data'. I want all of the approximately 40000 rows and in their original order (not in ascending order). How do I fix this?
Here is the link to report on the google drive.
https://drive.google.com/file/d/1Ky0Duon9vq2ObIBSQvd_G8BLjBmdADgu/view?usp=sharing
I have now solved this issue. The cause of it was the drop_duplicates command that is automatically done within the script of the python visualization. It was solved by adding a column consisting of integers from 1 to the number of rows, which ensures that no duplicates are removed and allowed me to rearrange the dataset back to what it was
Hi @William29 ,
You may need to check if the packages you are using were supported in Power BI.
https://docs.microsoft.com/en-us/power-bi/connect-data/service-python-packages-support .
Best Regards,
Jay
User | Count |
---|---|
73 | |
70 | |
38 | |
23 | |
23 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |