An internal error occurred wile using direct Query to Bex

[Anonymous]

Hi Team,

I am trying to create direct query connection to Bex, However getting error:

I have simple bex with 10 charecteristics and 3 measures. No local calculation in Bex

Allow external access checked

No auth variable

I can execute in RSRT and Analysis for excel.

Please suggest if there is some thing i am missing

I have used Direct query option with .net 

Regards,

Manveer Nakoti

[v-xiaoyan-msft · Accepted solution]

Hi@Anonymous,

There is a similar issue have been submit to PG. ICM: 223523015 , and I get this from that icm:

This is a known regression that will be fixed in the February release of Desktop. Please ask the user to stay with the November release of Desktop until the fix is released.

As workaround, you could try to use November 2020 version to have a try. 

https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive

I will update here once I get any information.

Hope it helps.

Best Regards,
Caitlyn Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.