Forum Discussion
Card visual - Power BI based on SharePoint List
I tried it, and can confirm that even though we set the calculated column as "number", when visualizing in pbi, it doesnt recognize it as "number". After a few tests, looks like any type of calculated column, will be returned as text. I think its the integration to power bi is the issue not the sharepointlist itself, as if it is not converting the data type properly into power bi.
A better option would be (see if this work for your situation), to create a proper pbi report.
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-sharepoint-online-listThe integrate to power bi function on sharepoint list is convenient, but has alot of limitations. But this limitation that we are encountering, is not listed.
https://learn.microsoft.com/en-us/power-bi/create-reports/service-quick-create-sharepoint-list#considerations-and-limitations
Thank you so much! The limitations are really annoying. I'll switch to the desktop version.
Hi,Tutu_in_YYC ,thanks for your concern about this issue.
Your answer is excellent!
And I would like to share some additional solutions below.
Hello,RitaHL .I am glad to help you.
As Tutu_in_YYC suggested, there are some limitations regarding the Power BI integration with SharePoint lists, so the better way is to create reports on Desktop, thank you very much for your understanding and support of Power BI. You can mark as solution the suggestions that help you, so that more forum users with similar issues can quickly find a better way to solve the limitation and make the right adjustments in time.I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian