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.

Markusb's avatar
Markusb
Frequent Visitor
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

    How did you changed from sql login to aad account?

    • Markusb's avatar
      Markusb
      Frequent Visitor
      3 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        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