Forum Discussion
problems with directquery to dynamics cds
- 6 years ago
lbendlin, i'm not sure I understand what you mean.
because it does load the data from db tabel systemuser into dbo_systemuser, which i load directly into the pbi datamodel.
it looks fine in the powerquery window (ie. i see the data), but as soon as I apply and load it into pbi it breaks.
unless I switch from directquery to import. that will fix the issue...
okay. this i strange. I was about to get some screenshots of the issue.
and despite being broken for a few weeks, and i haven't change anything. it suddendly works...
i guess that i might have been a problem with cds endpoint
lbendlin, i'm not sure I understand what you mean.
because it does load the data from db tabel systemuser into dbo_systemuser, which i load directly into the pbi datamodel.
it looks fine in the powerquery window (ie. i see the data), but as soon as I apply and load it into pbi it breaks.
unless I switch from directquery to import. that will fix the issue...
okay. this i strange. I was about to get some screenshots of the issue.
and despite being broken for a few weeks, and i haven't change anything. it suddendly works...
i guess that i might have been a problem with cds endpoint
Hi fuglphoenix ,
Today, I find that this is listed as a known issue internally.
There are two scenario about it. One is with SSO enabled. This is still fixing.
Another is without SSO. It is fixed. If you meet this scenario, please try again to check if it is working on your site.