Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.