Forum Discussion

Jasperca's avatar
Jasperca
Regular Visitor
3 years ago

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

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 up...
Need Help
Jasperca's avatar
Jasperca
Regular Visitor
3 years ago

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