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.
If you want to get the real time data, I'll suggest you try with create the custom real streaming data in Power BI Service.
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.