Forum Discussion
Synapse view not showing the data
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.
hi Markusb , thank you for reply. It was already in organizational account. Do you think i am missing some rights? My case is similar to yours in synapse view is working but when i load it it power bi it is stuck on loading screen
Hmm, not sure. In mycase I got that error that the content couldn't be listed which means either ther folder or file does not exist or you don't have permissions. If it's just stuck on the loading screen I'm not sure. It may also depend on how your external datasource in Synapse is configured. What kind of credential are you using?
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
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.