Data not showing in Power BI service using Direct query mode but its showing in desktop

[Anonymous]

Hi team,

We recently are facing some direct query issue.

Data not showing in Power BI service using Direct query mode but its showing in desktop.

Even with 4 mb data tables, its unable to load.

Its giving the following error.

or its giving this error

Its working fine with direct query mode.

Please help me in understanding what can the issue be and how can we resolve it.

@ibarrau @GilbertQ 

[ibarrau]

Hi. I'm not a direct query expert but let's see. We might need futher information in order to help. For example, what's the direct query source? are you conecting to tables or views? have you created a data model in there?

The first error sounds like you haven't configured the conection to the source correctly, if it's on premise you need a gateway, if not then you need to edit the credentials.

There is a limit on the time and size of the result of the query that can produce an error like the second one. If the data model is not built correctly, it can take a lot of time. The error shows it last 225 seconds. Even if it continue, it doesn't make sense for a user to wait that long.

For using direct query correctly, please make sure to follow this guide: https://learn.microsoft.com/en-us/power-bi/guidance/directquery-model-guidance

I hope that helps,

[Anonymous]

Thanks for the reply @ibarrau ,

FYI, the report was running smooth ,until monday . No changes were pushed to report. It automatically started throwing these errors from Monday.
I am taking data from postgres and its connected to tables,not views.

Previously the data would come in 1- 2 seconds, nows its getting timed out and still data is not coming. If it was the proper configuration or data model problem, the dashboard would never have shown data, but it was running smooth from last 6 months.

What could have gone wrong, I definitely know that the issue is not from Power BI side, its either gateway issue or from where the data is coming. Because it stopped working ans started throwing error all of a sudden. 

And its not just this report, my other reports which were running in direct query all stopped working but the ones with import mode is working fine.