Forum Discussion

Regular Visitor

3 years ago

Power Bi with SQL server (on premise) real time connection in Power App

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 tile that is linked to this database to show some visual...

Need Help

Jasperca

Regular Visitor

3 years ago

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.