Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Update Power BI from an app

Dear I have a query that I can not solve and it is the following: I have reports published in PowerBi these are associated with a SQL server Database and connected to a GateWay, which I have sche...
v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Syndicate_Admin 

 

I would like to know how your data is connected, Import or DirectQuery ? SQL server supports DirectQuery mode.

 

It allows user to see the updated data in the report via DirectQuery even if you hadn’t configure scheduled refresh. Users can refresh the data by themselves with the icon as the following image show.

 

If you use the Impoert mode ,the dataset can only be updated by the dataset’s owner.

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    4 years ago

    wave, I used the Direct Query connection with SQL, but it is very limited, that is, it did not allow me to make queries to functions, it was very slow at the time of connection, so I decided to always work in Import and with the Gateway update it automatically every 3 hours (which is the maximum allowed)