I got this error when I try to publish my report via DirectQuery. My data source is from azuer synapse I got different credential to access the connection string here, I also have different credential using both in PBI desktop & web app.
I have no problem publishing it in PBI desktop side, however, I got this error when I try to see the report in PBI web app.
Error I got when I try to use the credential I use in accessing azure synapse:
enter image description here
This is the error I got in PBI web:
enter image description here
Any help is appeciated.
Solve my credential issue.