Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - AI Builder / Import data for Predic...
Power Apps - AI Builder
Unanswered

Import data for Prediction Model

(0) ShareShare
ReportReport
Posted on by zdzunic 46

Hi , I try to test Prediction Model in AI Builder. I have a problem with importing data. I use standard dataset for churn prediction WA_Fn-UseC_-Telco-Customer-Churn.csv where I changed values for Churn columns (instead "Yes" and "No" a changed to "True" and "False". Then I deleted the first 10 Churn values (for further testing purposes after training model).

But during import this values changed automatically in "NO". During Import Churn column is "Yes&No" type and this data type has only to values with "No" as a default. How can I fix this and prepare data for training and after that for testing predictive model?

Categories:
AI Builder
  • Norah Profile Picture
    Norah on at
    Re: Import data for Prediction Model

    hi @zdzunic 

     

    Do you mind send an email to AI Builder Help English <aihelpen@microsoft.com>? We can set up a call to see how it reproduce and how to unblock you.

     

    Thanks

    Norah

  • zdzunic Profile Picture
    zdzunic 46 on at
    Re: Import data for Prediction Model

    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 have 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_onlineshopperintention.csv
    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)

     

    Do you make the same procedure or there are some differences?

    Thanks!

    1.jpg
    3.jpg
    2.jpg
  • Norah Profile Picture
    Norah on at
    Re: Import data for Prediction Model

    hi @zdzunic 

     

    Do you mind share with us how you import the data? And did you hit any errors when importing?

     

    Based on your description, the first assumption I had is did you change the Yes&No field value in your Dataverse? We recently renamed "two-option value" type to "Yes&No", and CDS to Dataverse Pro. But Yes&No type of column doesn't mean that the column has to be Yes or No, it only means this column should only have 2 distinct value. See definition here: Column data types in Microsoft Dataverse - Power Apps | Microsoft Docs

     

    The sample table might have "Yes" and "No" baked in the table schema. But before importing, you can change the Yes&No items, please go to your make.powerapps.com portal, navigate to Tables tab and find the table you're importing to. Click on that Yes&No field (churn column in your case), then see if you can edit the items. If you don't have permission to do so, could you please add a new Yes&No column and assign it the True/False item value? 

    edit yes&no 1.png

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Question for everyone : How are you using Create Text GPT in AI Builder?

Product updates

Microsoft Power Platform Community release plans