Tabular Editor Error 401

[chiru5262]

Hi

I am trying to add perspectives to a report where it is in a separate file from the model.

When I try to open Tabular Editor from the External tools ribbon, the following error message is displayed:

"Error connecting to database - The remote server returned an error:(401) Unauthorized"

This issue does not appear in reports where it is in the same file/pbix as the model.

Please advise

Thanks

Chiranjeevi

[Yuvarajand]

Did you ever find a solution? We have started using TE3 and I recall being able to connect to a thin report. Maybe I am wrong. Can you clarify if it's just the model datasets that we can connect to?

[Anonymous]

Hi @chiru5262 ,

Could you tell me if my post helps you a little? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.

Hope to hear from you‌‌😀

Best Regards,
Eyelyn Qin

[chiru5262]

Hi @Anonymous , sorry but none of them worked.

For some reason the tabular editor is unable to connect the power bi live dataset.

I'm assuming it doesn't support live power bi dataset.

But any help or alternative ways to copy measures from one report connected to power bi live dataset to other report would be appreciable.

Kind Regards,

Chiranjeevi

[Anonymous]

Hi @chiru5262 ,

Here is a workaround provided by @Hendrik_LI  from a similar thread , please check if it could help you a little:

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

[chiru5262]

The Thing is I've bunch of measures sitting in the Thin report which I want to bring it to the model.

The people who worked earlier on the report didn't do the stuff in an efficient way which I'm trying to do it correctly which is having all the measures in the model.

So wondering if there is any way I can bring the measures sitting in a couple of thin reports to the model.

Please advise.

Thanks

Chiranjeevi

[chiru5262]

Is it like  external tools don’t detect Power Bi models

[amitchandak]

@chiru5262 , You have opened Tabular editor from the external tool tab in power bi?

[chiru5262]

Yes , its a power bi data model which I'm unable to connect