Can't preview/load views inside Azure Synapse SQL server through Power BI

Question

I keep having the same issue when trying to access data resources from Power BI. I have the required permissions to get into the Azure Synapse Analytics SQL server, but once I am in, any table I am trying to preview or load is disabled for me, saying "DataSource.Error: Microsoft SQL: Content of directory on path '****/**' cannot be listed. Could not use view or function 'bronze.vw_ebs_ar_cash_receipts_all' because of binding errors." On Azure Data Studio I can load the tables without any problem. So the problem must lie in Power BI. Does anybody have any clue? For the Azure Synapse resource, I am both contributor and storage blob contributor.

Answer 1

@David Slings - I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer .

Ask: Can't preview/load views inside Azure Synapse SQL server through Power BI

Solution: I have solved the issue, it had to do with the data source settings inside power bi - i wasn't logged in with the right credentials there.

If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.

If you have any other questions, please let me know. Thank you again for your time and patience throughout this issue.

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 2

I have solved the issue, it had to do with the data source settings inside power bi - i wasn't logged in with the right credentials there.

Answer 3

Have you tried to query your view o, the DB directly first ? Because it may be generating some errors. Also, even though you have contributor and storage blob contributor roles, double-check the permissions at the database level. Sometimes, specific permissions required for Power BI to access certain views or functions are not granted. One more thing If you're using an on-premises data gateway (here I assume you are working with SQL Server), ensure that it's properly configured and up to date. Power BI uses this gateway to connect to many data sources, including Azure Synapse Analytics.