I Have two Data Sources one is O Data feed and Other is Sql Server.

[Anonymous]

I Have two Data Sources one is O Data feed and Other is Sql Server.  

i need to show the count of devices enrolled everyday from each datasource. in Line chart comapring both datasources.

O Data feed has three columns              Sql server has three columns 

date, Devices, serialnumber                    date, Devices, Serialnumber

i have created a calender date and joined both the tables to claender date and used the calender date in axis.

In Values i kept one serial number coulmn from sql server datasource as distinctcount. I can see the line chart and count.

But when i kept odata serial number in values as countdsitinct both at once its not working. In this case how to show both count of serial number per day enrolled comparing both in line chart. 

is it possible in Power BI. If possible how.

[v-xiaotang]

Hi @Anonymous 

Have you solved this problem yet? If yes, could you kindly accept the answer you find useful as the solution? or share your solution so that others have same problem can refer to it?

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution✔️ to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous ,

if the data is imported them merge the two tables.

Or you need to have a common date table at least.

then you can show the data from two table across common date table .

You need to be in star schema

https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/

https://www.seerinteractive.com/blog/join-many-many-power-bi/

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.