Forum Discussion
Report not working in On-Premise Report Server
Hello Charlie,
We are connecting to SQL Server database (relational) and able to select Direct Query when configuring this data source. Can you help to understand difference between using import data and direct query options. Right now, these both options appear to have same behavior.
And we are not looking for scheduled refresh as we alreay know the limitation. We are trying to refresh data only by manually clicking on the button available when report is open.
However, I also found the below link that is informative.
Regards,
Khalid
Community Championkhalidsk you cant refresh even manually from report server as far as i know, the only refreshable and the use of the world refreshable is debatable, is when you have direct query to SSAS.
If you connection via a sql server relational db you need to open up the report in power bi desktop and refresh it there and then re upload / publish to ther report server.
the difference between imported and direct query is imported means you pull the data physically into the model and it is then stored in the model. Direct query means that the data is just pointing to the source of data via the connection and is always looking at the latest data therefore no refresh is needed, with imported you need to refresh the data.