Card visual - Power BI based on SharePoint List

[RitaHL]

Hi there,

I'm trying to visualize a SharePoint list using "Integration" --> Power BI --> Visualize this list.

Then I tried to add a card visual to the dashboard. The data point is a numeric calculated column that returns the number of days between two dates.

What I found frustrating is that I cannot use the average value of this column. The only selections I have are "First, Last, Count, Count (distinct)".

I doublechecked that the data type of that column is "Number". 

Am I missing anything? 

Thanks a lot in advance!

[RitaHL]

Thank you so much! The limitations are really annoying. I'll switch to the desktop version. 

[Anonymous]

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

[Tutu_in_YYC · Accepted solution]

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-list

The 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#consi...