Answered

Dataflow issue when trying to connect table in Power Query

(0) Share

Report

Posted on by Vw123

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!

Categories:

Power Query

I have the same question (0)

All responses (3)

Answers (1)

Vw123 35 on at

Like (0)

Report
Copy link

Link copied!

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
Details
DataSourceKind = CommonDataService
DataSourcePath = org9c765cbd.crm4.dynamics.com
Message = "Invalid object name 'dbo.cr7a7_testtable1'." RequestId: TDS;8f7c93ff-4f0a-45e6-a6ca-29dfbae35684;9 Time: 2023-08-06T17:50:17.9513513Z
ErrorCode = -2146232060
Number = 40000
Class = 16

Was this reply helpful? Yes No
Vw123 35 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Verified answer

Vw123 35 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No