Forum Discussion

Markusb's avatar
Markusb
Frequent Visitor
4 years ago
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. ...
Need Help
  • Markusb's avatar
    Markusb
    4 years ago

    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's avatar
Anonymous
Not applicable
3 years ago

do you add external datasource in openrowset? I tried adding external datasource the qury shows that it ran perfectly when i click on message tab there is thsi error . I am getting the result in synapse even without using externaldata source

 

Markusb's avatar
Markusb
Frequent Visitor
3 years ago

You don't have to use a external data source, but I did and I think it makes it easier if you want to re-use the same storage account in the future.

The error indicates that there is no data in your location.

I really can't tell what is going wrong, if the location is exactly the same as you used before and the credentials for the datasource are correct it should work.