cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
zdzunic
Helper I
Helper I

Data Preparation for AI Builder Sample

Hi,

please can somebody test data preparation for this AI Builder sample for Prediction model and 

https://docs.microsoft.com/en-us/ai-builder/prediction-data-prep

It seems that doesn't work any more, it is'n possible any more to import rows with target value null (Revenue (Label)).

 

Thanks!

 

 

4 REPLIES 4
Norah
Power Apps
Power Apps

hi @zdzunic 

Could you tell me at which step in the doc you see the error of not able to import null value? Did you map the columns correctly when importing? Because I just tried to follow instruction in the doc above to import data, and it worked for me.

 

null data.png

Hi @Nora,

Thank you for your answer. I got no error, but the "Ravenue" field get "No" value.

Could you tell me which data type did you use for "Ravenue" field, or have you made other transformation in table OnlineShopperIntention bevor the import ?

Thanks!

hi I'm sorry to hear the issue. 

 

Pasting the schema I'm using, the Revenue field is a Yes/No field.

 

schema.png

zdzunic
Helper I
Helper I

Hi @Norah ,

I checked import once more but i got again the same results ( null values in .csv file for Revenue field are after import "No")
Here are the steps what i done:

1. Import solution AIBuilderOnlineShopperIntention_1_0_0_0.zip (which i downloaded from git)
2.Check the table definition (aib_onlineshopperintention) in dataverse after importing solution (attachment 1)
3. "Revenue" field is "Yes/No" with default Value "No" but "optional"
4. Get data (https://raw.githubusercontent.com/microsoft/PowerApps-Samples/master/ai-builder/aib_onlineshopperint...
5.From import, customer1 to customer 29 have aib_Revenue field "null" (attachment 2)
6. Field aib_Revenue is {"aib_Revenue", type logical}})
7. Load .csv file into existing table (aib_onlineshopperintention)
8. Auto map
9. Check the values for aib_Revenue field in table (attachment 3

Did you make the same procedure or there are some differences?
I am sure that was working earlier

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

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.

Top Kudoed Authors
Users online (1,051)