Currently, I am getting a real-time data through API from the sensor and I am dumping that data to the Cosmosdb directly and then accessing that data from CosmosDb connector. But the problem in this approach is I am not getting the realtime value, every time I need to refresh the dataset manually. Is there any best solution for doing this work. What is the best approach I can implement? Please suggest.
If I understand your scenario that you connect with Azure Cosmos Database in Power BI Desktop and create the report, then publish it in Power BI Service. However, you cannot get the real time data until you refresh the dataset manually.
If that is your case, I'm afraid that is right step for your scenario as we will get the update data after refresh.