Data is not coming up on live

[Anonymous]

Hi Team,

i got one issue that  when i open the power bi report on desktop version then data is coming up but data is not coming on live.

could you please help me how can i trobleshoot the issue ?

[Icey · Accepted solution]

Hi @Anonymous ,

---

... when i open the power bi report on desktop version then data is coming up but data is not coming on live.

---

Do you mean that your report doesn't show the latest data in Power BI Desktop?

If so, it is needed to manually refresh when connectivity mode is Import or DirectQuery.

For import, when using Get Data in Power BI Desktop to connect to a data source like SQL Server, the behavior of that connection is as follows:

• During the initial Get Data experience, the set of tables selected each define a query that will return a set of data. Those queries can be edited before loading the data, for example, to apply filters, or aggregate the data, or join different tables.
• Upon load, all of the data defined by those queries will be imported into the Power BI cache.
• Upon building a visual within Power BI Desktop, the imported data will be queried. The Power BI store ensures the query will be fast. All changes to the visual are reflected immediately.
• Any changes to the underlying data aren't reflected in any visuals. It's necessary to Refresh to reimport data.

For DirectQuery, when using Get Data in Power BI Desktop to connect to a data source, the behavior of that connection is as follows:

• During the initial Get Data experience, the source is selected. For relational sources, a set of tables are selected and each still define a query that logically returns a set of data. For multidimensional sources, like SAP BW, only the source is selected.
• However, upon load, no data is imported into the Power BI store. Instead, upon building a visual within Power BI Desktop, queries are sent to the underlying data source to retrieve the necessary data. The time taken to refresh the visual depends on the performance of the underlying data source.
• Any changes to the underlying data aren't immediately reflected in any existing visuals. It's still necessary to refresh. The necessary queries are resent for each visual, and the visual is updated as necessary.

Reference: Using DirectQuery in Power BI - Power BI | Microsoft Docs

Best Regards,

Icey

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