Forum Discussion
powerbi datatypes problem with SharePoint List
thanks for the link. I will investigate abit alternatives because it is the first time i created a sharepoint list using excel upload feature. In most other Sharepoint Lists created manually from scratch, never had this issue in powerbi.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-types
actually I think what you experiencing is correct, however it should do an automatic conversion
'This article describes data types supported in Power BI Desktop and Data Analysis Expressions (DAX).
When you load data into Power BI Desktop, it will attempt to convert the data type of the source column into a data type that better supports more efficient storage, calculations, and data visualization. For example, if a column of values you import from Excel has no fractional values, Power BI Desktop will convert the entire column of data to a Whole Number data type, which is better suited for storing integers.
This concept is important because some DAX functions have special data type requirements. While in many cases DAX will implicitly convert a data type for you, there are some cases where it will not. For instance, if a DAX function requires a Date data type and the data type for your column is Text, the DAX function will not work correctly. So, it’s both important and useful to get the correct data type for a column. Implicit conversions are described later in this article.'
thanks for the link. I will investigate abit alternatives because it is the first time i created a sharepoint list using excel upload feature. In most other Sharepoint Lists created manually from scratch, never had this issue in powerbi.