Forum Discussion

mbilal079's avatar
mbilal079
New Member
3 years ago

Facing an issue while connecting with Dataverse

I'm getting the Opportunities table from Dataverse but getting the below error.   DataSource.Error: Microsoft SQL: Invalid column name 'accountid'. Invalid column name 'accountidname'. Invalid co...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi mbilal079 

 

Try opening Power Query Editor and clicking "Refresh Preview" in it. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

  • mbilal079's avatar
    mbilal079
    New Member
    3 years ago

    Hi v-jingzhang 

     

    Thank you for your response.

     

    I have refreshed it a couple of times but still having the same issue.

     

     

    Thank You!.

  • PaulDG's avatar
    PaulDG
    Regular Visitor
    3 years ago

    This was the solution for me- thanks, I believe I deleted a couple of columns in the datverse table that was throwing out power BI. Didnt think to refresh the query as I just created it but it must have been working of a cached schema or something