Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Cannot connect to view...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Cannot connect to view in Synapse Analytics SQL database

(1) ShareShare
ReportReport
Posted on by Frode Magnussen 60

Hi,

Not sure if this is the correct forum for this question.

I have setup a Synapse Analytics Workspsace and a link to replicate Dataverse to a serverless SQL pool. We then have a connection to this database setup in PowerBI and that is working fine.

As you cannot create views for a replicated database we then setup a new SQL database on the same workspace and created a view and selected data from the Dataverse replication database.

When connecting PowerBI to this view it throws an error saying:

Expression.Error We cannot apply field access to the type Null.

Details:

Value=

Key=StorageDescriptor

pastedimage1649176161686v4.png

pastedimage1649176264945v5.png

Anyone have any tip or suggestions to solve this issue?

  • Siopold123 Profile Picture
    Siopold123 on at
    RE: Cannot connect to view in Synapse Analytics SQL database

    Hi Frode, were you able to get an answer to this question. I have a similar issue where I have created a view in synapse against data lake CDM output I can run the view and join it etc in Synapse when I attempt to access via PowerBI on the simplest view I get this issue. What does it actually mean?

    Expression.Error: We cannot apply field access to the type Null.

    Details:

       Value=

       Key=StorageDescriptor

  • Suggested answer
    Dmitrii Solovev Profile Picture
    Dmitrii Solovev 5 on at
    RE: Cannot connect to view in Synapse Analytics SQL database

    Well, it looks like a bug of a Synapse workspace connector. Have the same behavior when querying data from serverless pool. Works well if use Azure SQL connector: docs.microsoft.com/.../tutorial-connect-power-bi-desktop

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans