refresh data for published report

[borys86]

Hi there. How to refresh data of a published report? An example: I made a report, published it. Cosmos Db is constantly updated. In a while new data is added to Cosmos db. How automatically update the report so anyone can access latest data?

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: db43c478-6301-7b69-131a-c4289797c49d
• Version Independent ID: 5f991bdb-919e-f712-1fe0-050eba25ebaf
• Content: Power BI tutorial for Azure Cosmos DB connector
• Content Source: articles/cosmos-db/powerbi-visualize.md
• Service: cosmos-db
• GitHub Login: @SnehaGunda
• Microsoft Alias: sngun

[Alberto-Vega]

@borys86 Thanks for the feedback! We are currently investigating and will update you shortly.

[borys86]

I found this suggestion, to use Spark to push updates from Cosmos DB to the report via Spart but this is insane. https://github.com/Azure/azure-cosmosdb-spark/wiki/Configuring-Power-BI-Direct-Query-to-Azure-Cosmos-DB-via-Apache-Spark-(HDI)

What I want is probably something like DirectQuery mode for SQL Server.

[SnehaGunda]

@borys86 report refresh is not yet supported by PowerBI.com when using Cosmos DB data source. The support should be enabled from the Power BI team it can't be added from Cosmos DB. I have seen couple of other users request for this functionality over the past months. Can you please vote or log a feature request in the Power BI user voice: https://ideas.powerbi.com/forums/265200-power-bi-ideas

[SnehaGunda]

please-close

[Alberto-Vega]

@borys86 There are a couple alternatives for you to explore:

• Easiest one is the scheduled refresh for Power BI, you could schedule a daily refresh or as often as your need to. Just please be mindful that it will be querying your Cosmos DB, so as you do refresh more often it might incur in more Request Unit (RU) charges. You can learn more Power BI Scheduled Refresh documentation

• This one is a little more involved. You could use Power BI refresh API and Azure Cosmos DB Change Feed. To learn more about how they work and see some how to guides please read these docs Data Refresh API and Azure Cosmos DB Change Feed. Azure Cosmos DB Change Feed will allow you to listen for changes or updates in your database and trigger the API call to Power BI refresh every time there is a change. You could use a logic app or an azure function to trigger the API call, You just will need to evaluate which one works better for you.

We will now proceed to close this thread. If there are further questions regarding this matter, please tag me in your reply. We will gladly continue the discussion and we will reopen the issue.

[tanwarsatya]

A report without data refresh, what is the use of it. This feature is in request from last 2 years and no response on that or a date for that. @Alberto-Vega-MSFT schedule refresh only allow daily or weekly refresh, what if data is changing more frequently. Now talking about building the functionality to call the refresh api on change feed is insane, refreshing the data is a basic functionality for any kind of reporting tool.

[rslavey]

Can you tell me if there is any progress on this? I have a Cosmos DB Power Bi report that will not refresh.