Forum Discussion

Jasperca's avatar
Jasperca
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
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

From Power BI connect to the SQL server data source in Direct Query mode, and then set up APR (automatic page refresh) on the appropriate report page.

Jasperca's avatar
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.

 

Does this mean I have to connect to my SQL server directly from Power Bi Desktop in order to avoid to refresh my dataset manually?

 

Thank you

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    As I said you also need to set up APR.