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.
How did you changed from sql login to aad account?
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.
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