cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Roco Regular Visitor
Regular Visitor

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 works, but not in the Report Server. I think this may have started after i have upgraded the Report Server to the new version (August 2018). I already have done some seach but haven't yet found the cause of this problem...

 

Do you have an idea of what may be the problem? May it be related with the ew version of the report server?

 

Best Regards,

RoCo 

1 ACCEPTED SOLUTION

Accepted Solutions
Jon-Heide Established Member
Established Member

Re: Direct Query not working in Report Server

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. 

1 REPLY 1
Jon-Heide Established Member
Established Member

Re: Direct Query not working in Report Server

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. 

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 367 members 3,738 guests
Please welcome our newest community members: