Forum Discussion
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.
Now when I first created this data source There was an error because one of the files in ADLS was missing and I got an error
"Datasource error Content of directory https://mydatalake folder cannot be listed.
Could not use view or funcion dbo.myView because of binding error."
At that moment in time that was correct and expected.
I now loaded the file into the ADLS again and the view works in Synapse, but in Power BI Desktop I keep getting the same error. Clicking on refresh doesn't change this.
I when tried removing the data source and re-creating it but no difference.
I even uninstalled PBI Desktop and did a new installation, but I still keep getting this error.
What can I do to get this view working in PBI Desktop?
Any help is appreciated.
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.
8 Replies
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.
Anonymous Just change the authentication in our Power Bi datasource to organizational. Remember in my case the view in Synapse was working, only when accessing the view from Power Bi it did not work.
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?
