cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rossData
Frequent Visitor

Power BI Showing Blank Cells after Python Script

I've created a python script that takes in two different queries. When I run the script with extracts in visual studio the output is as desired, but when I run the script in power bi some of the rows have blanks in the last 3 columns. I've done some debugging and found that if I force the result as a string they come through as nan, but this still doesn't line up with the test output. My other thought was that the code that grabs those values was in correct, but then it wouldn't work for the ones that do work. I've also checked to see if there are any differences between the data that I'm pulling in and I cannot find any.

1 ACCEPTED SOLUTION
rossData
Frequent Visitor

Figured it out. The table I was pulling data from had 264 columsn. Moved the columns I needed to the front and it pulled the data for all rows correctly. It's odd that it pulled some rows and not others, but now it works.

View solution in original post

2 REPLIES 2
rossData
Frequent Visitor

Figured it out. The table I was pulling data from had 264 columsn. Moved the columns I needed to the front and it pulled the data for all rows correctly. It's odd that it pulled some rows and not others, but now it works.

View solution in original post

dax
Community Support
Community Support

Hi rossData,

So it seems that you solve your issue, right? If so and if you'd like to, you could mark corresponding post as answer or share your solutions. That way, people who in this forum and have similar issue will benefit from it.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors