Couldn't load the data for this visual

Hi,

I have created a Line chart using an azure connected sql query using the desktop successfully. But after publishing , in my application it throws error as Couldn't load the data for this visual . 

The SQL query is queried against the same database tables, has a union of two sub queries and not huge data also.I checked all other posts with the same subject issue and couldnt find anything that helped me.  

Is it something to do with the query. But chart is created fine in desktop .