Forum Discussion
Anonymous
7 years agoNot applicable
Direct Query not working in Report Server
Good Afternoon, Recently i noticed that one Report which i is using direct query is not refreshing the data in the Report Server. But when i open the report in Power BI and refresh it the query w...
- 7 years ago
Confirm that you are using a data source type that is supported for refresh: https://docs.microsoft.com/en-us/power-bi/report-server/data-sources
Otherwise, double check the credentials used for direct query have not expired or are still correct. Lastly, you can look at the report server log/trace files to see if there is a more specific error as to what is happening.
Jon-Heide
7 years agoMicrosoft Employee
Confirm that you are using a data source type that is supported for refresh: https://docs.microsoft.com/en-us/power-bi/report-server/data-sources
Otherwise, double check the credentials used for direct query have not expired or are still correct. Lastly, you can look at the report server log/trace files to see if there is a more specific error as to what is happening.