Forum Discussion

dataguy9980's avatar
dataguy9980
Regular Visitor
9 years ago

Column detected as Text instead of Number

Possibly a simple question.   I'm connecting to a .csv file in OneDrive and one of my columns (-1 to 12 values) are being detected as text and I can't seem to find where to 'override' Power BI to f...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

dataguy9980 You need to create a connection to Web and input the external url for the folder containing the csv. see here

dataguy9980's avatar
dataguy9980
Regular Visitor
9 years ago

I tried it that way too.  I think the problem was I published the 'Report' and not the PBIX file.  Like I said, I'm new here!

 

Playing with saving the PBIX file to OneDrive and selecting that as the dataset source now.

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    Hi dataguy9980,

     

    After you use the way suggested by Anonymous to get data from .csv file in Power BI desktop, you can save the .pbix and publish it to service follow this article: Publish from Power BI Desktop. You needn't to upload the .pbix to OneDrive. Then you can enter the credential for data source and schedule refresh below:

     

     

    Reference:
    Configuring scheduled refresh

     

    Best Regards,
    Qiuyun Yu