Announcements
I'm having an issue where I try to connect to my dataverse table using dataflow in order to append two tables. I have tried to recreate the dataflow several times, but it keeps giving me this error once I try to choose the tables in power query. Any help much appreciated!
The error message:
DataSource.Error: Microsoft SQL: "Invalid object name 'dbo.cr7a7_testtable1'." RequestId: TDS;8f7c93ff-4f0a-45e6-a6ca-29dfbae35684;9 Time: 2023-08-06T17:50:17.9513513Z
For some reason I got it working. I changed the dataverse table properties to "can have connection", but I don't know if that did the trick. Its strange because it worked yesterday when I did this on my work computer on a different tenant and environment, creating two tables and I got this part working there immediately without touching the properties.
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 549 Most Valuable Professional
Kalathiya 225 Super User 2026 Season 1
Haque 224