Power Bi with SQL server (on premise) real time connection in Report (PowerBi Service)

[Jasperca]

Hi Everyone

We currently have a Power App (canvas) where we can add new records to an SQL server database. Next to this we have a Power Bi Report that is linked to this dataset. The goal is to update the Report as frequenty as possible, since new records will be created every minute. 

Is it by any chance possible to have the SQL server and the linked PowerBi dataset always synced so we can see the data show up in real time (or almost in real time) inside the report? We don't mind clicking the Refresh Visuals button in the report. As long as the dataset is up to date without having to schedule refreshes.

What are our possibilities here?

Thank you so much!

[Idrissshatila]

Hello @Jasperca ,

You could try using Direct query Mode
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Jasperca]

Hi @Idrissshatila 

Thanks for the response.

The dataset is already present in a workspace inside of Power Bi service.

If I open up Power Bi Desktop and choose that dataset (Power Bi datasets) it shows ‘Connected live to the Power Bi dataset …’. If I want to make some changes to it I can click ‘Make changes to this model’.

Then it automatically switches it to DirectQuery after it asks me to add a local model.

But no matter what, whenever I want to see the latest data inside of my visuals, I still need to refresh the dataset by clicking the Refresh now icon.

Thank you