Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi team,
I have just updated my PBI Desktop version to 2.67.5404.801 (64-bit). After the update, I have noticed that when connecting to a SharePoint list using the SharePoint List connector (on prem SharePoint), any numerical or date field are being uploaded as simple text fields in PowerBI. This is then requiring manual intervention to change the data type in order to perform numerical calculations on the 2 data types.
I have tested with Excel for example and in this case, PowerBI is transforming automatically to the right data type.
Also, as a workaround for SharePoint list, while using the oData feed version of loading the list, the transformations are done again automatically, just as expected.
I think this is an issue, please help me investigating it and eventually correcting it.
Many thanks,
Theo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.