Forum Discussion
Solved
Synapse view not showing the data
I have create a Synapse view on a serverless pool which queries ADLS. I created a Power BI datasource usig the Azure Synapse Analytics connector with import mode. I can connect and can see my view. ...
Ok, I think I've soved it.
The problem seems to be that the SQL login doesn't have permissions on the datalake. I now changed it to my AAD account which does have permissions on ADLS in the data source and can now view the data in PBI.
Just wanted to add two things. My datasource to Synapse is using SQL authentication.
I created a new view (with the same content) and still get this error. Could it be that the SQL authentication is the issue?