sPublished Report not displaying any data

[HB13]

Hello everyone!

I have a set of reports that once published and refreshed online, stops displaying data in its visuals. The reports refreshes via an on-premise gateway set up on one of my client's servers. 

The data model is made up of two SQL tables (Table_1 & Table_2), and I've found that once removing all the filters coming from Table_2 only then do the visuals display data. I've seen issues like this related to boolean type columns being used as filters, but this is not the case here.

If I open the files in desktop there the visuals with the filters are fine. But, I have also had issues refreshing Table_2 in desktop... it times out or comes back with a "error on current command, discards results if any".

Does anyone know what the issue could be with this particular table? What kind of permissions in SQL would cause an issue like this? What else can I try?

Many many thanks

[HB13]

Hi Henry

Thank you for your reply. 

The connection pattern for both tables are imports. I have had a look into a composition model, where I use DirectQuery for the "problematic" table, but it takes ages to load any data and then comes back with this message (see pic)

I do not know the exact permissions and workings of this table in SQL server, that is handled by another team so I am not sure how to go about checking what issues there may be on that side. Do you perhaps know what I could ask them to look into on their side?

Thanks and regards

H

[v-henryk-mstf]

Hi @HB13 ,

Seems a bit odd. From a powerbi perspective, what is the connection pattern of your data sources respectively?

related document

Use composite models in Power BI Desktop - Power BI | Microsoft Docs

On the other hand, for this type of error hint, it is usually triggered by an error in SQL Server. Does it help to refer to the following similar solution.

.net - What does "A severe error occurred on the current command. The results, if any, should be dis...

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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