We cannot return a value of type Table in this context

[Analitika]

Something went wrong

There was an error when processing the data in the dataset.

Please try again later or contact support. If you contact support, please provide these details.

• Data source error{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"We cannot return a value of type Table in this context."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: DBA OBJEKTAS.
• Cluster URIWABI-WEST-EUROPE-B-PRIMARY-redirect.analysis.windows.net
• Activity ID7dc91d32-82c6-4ac7-a75f-55265e59ecda
• Request IDb08bb972-77cc-acb6-ef65-474bbbb41304
• Time2020-08-25 13:01:56Z

 DBA OBJEKTAS.

let
Source1 = DBA_1,
DBA_view_DidknObj1 = Source1{[Schema="DBA",Item="OBJEKTAS"]}[Data],

Source2 = DBA_2,
DBA_view_DidknObj2 = Source2{[Schema="DBA",Item="OBJEKTAS"]}[Data],

Append = Table.Combine( {DBA_view_DidknObj1 ,DBA_view_DidknObj2} ),
#"Removed Duplicates" = Table.Distinct(Append, {"OBJ_KOD"})
in
#"Removed Duplicates"

DBA_1

let
Source1 = Sybase.Database(SelectServer, SelectDatabase1)
in
Source1

DBA_2

let
Source1 = Sybase.Database(SelectServer, SelectDatabase2)
in
Source1

Not one of private level settings not working, result the same

[V-lianl-msft]

Hi @Analitika ,

Based on the M code you provided, the data comes from two different databases.

If your dataset not only contains cloud data source but also the on premise data source, then it needs to use the gateway and configure schedule refresh,refer:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloud 

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

[Greg_Deckler]

@Analitika - Does the refresh work in Desktop? Are you getting this in the Service? You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[Analitika]

only in WEb Service, in desktop no problems

How to check wich license type i have?