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

David Slings 25 Reputation points
2024-01-19T10:06:31.25+00:00

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.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,186 questions
0 comments No comments
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA 90,541 Reputation points
    2024-01-25T04:54:54.6133333+00:00

    @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.

    1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
  1. David Slings 25 Reputation points
    2024-01-23T08:51:17.17+00:00

    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.

    1 person found this answer helpful.

  2. Amira Bedhiafi 28,536 Reputation points
    2024-01-21T13:24:49.0833333+00:00

    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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.