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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

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.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.