Ramandeep Singh
1 min readJan 22, 2019

--

So, basically you are dynamically changing the underlying data and want to show the latest data in the Power BI report. Power BI has multiple types of connection options: live connection, direct query and import mode. Refer this link for more details: http://radacad.com/directquery-live-connection-or-import-data-tough-decision

I guess if you have a direct query setup with the DB, then you just need to refresh the report using report.refresh() method or pbiService.embedNew() method to see the updated report.

In addition to this, if your start and end dates are UI only fields and not in DB then you can use Power BI client-side filtering provided in the JavaScript/TypeScript library.

Regarding RunId, if you are updating the same RunId through multiple users concurrently, then you will have problems.

--

--

Ramandeep Singh
Ramandeep Singh

Written by Ramandeep Singh

Programmer by day, gamer by night

Responses (3)