Data Source Error while connecting the views of Synapse to Power Bi

[Anonymous]

Hi ,

     When trying to connect the views created in Synapse to Power BI getting this error :

     File cannot be opened because it does not exist or it is used by another process.
     Could not use view or function 'dbo. ' because of binding errors

      Number=13822
      Class=16 

 Let me know if anyone has solution to solve this.

[agneum]

Do the Synapse views read files from Azure storage account? In that case that is related to permissions I believe

[Anonymous]

HI @Anonymous,

Please double check your connection string and data source status to confirm you are using the correct DB names and the data source connection has not to be locked/protect by other sessions.

Regards,

Xiaoxin Sheng