Couldn't load the data for this visual

[skancharla]

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 .

[v-caliao-msft]

Hi @skancharla,

Have you edit your credentials for your dataset? You need to edit your dataset crentials, so that you can refresh data.

Regards,

Charlie Liao