Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

QEDavidLayton

PowerBI Online Failure: We cannot convert the value "[Table]" to type Table.

Submitted by Advocate I on ‎05-28-2018 09:09 AM
 
Hello, 
 
When tying to refresh my PBI report from powerbi online a get the following message. However, works from Power BI desktop. Any ideas??
 
*************
Something went wrong

 

Cannot connect to the mashup data source. See error details for more information.
Please try again later or contact support. If you contact support, please provide these details.
Underlying error code-2147467259 Table: Z - AUX G/L Entries (2).
Underlying error messageWe cannot convert the value "[Table]" to type Table.
DM_ErrorDetailNameCode_UnderlyingHResult-2147467259
Microsoft.Data.Mashup.ValueError.ReasonExpression.Error
Microsoft.Data.Mashup.ValueError.Value[Table]
Cluster URIWABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID5090b617-97fb-47d0-b6aa-22e2a7fc24ac
Request IDf08853a8-6f77-4730-871a-f4feeb8d7f27
Time2018-05-22 16:21:32Z
**********************************
 
Thank you in advance.
Status: New
See more ideas labeled with:
2 Comments (2 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎05-29-2018 07:09 PM

Hi @QEDavidLayton,

 

In your scenario, do you configure the dataset to use on-premises data gateway or on-premises data gateway (personal mode)? Do you combine queries in the report? 

 

If it does, please make sure that when combining queries across data sources that the data does not contain any nested record/list/table/binary/etc. columns. It should only contain primitive values (text, dates, numbers, etc.). Columns with nested structures (such as records, lists, tables, or binary values) should be removed prior to performing a merge operation. Please open the report in Power BI desktop and check this section. 

 

Best Regards,
Qiuyun Yu

QEDavidLayton
Advocate I
Advocate I
‎05-30-2018 12:52 AM

Thanks a lot for your quick response Qiuyun Yu!!

 

We are trying with On-Premises Gateway and we perform all sorts of operations and across multiple datasources.

 

 I'll take in account your advise. Howerver, it seems Power BI update 14.16.6697.1 (May 2018) has solved the issue. 

 

If you see version updates:

• Impala SSO support using Kerberos is now available in limited preview
• Improved support for Kerberos SSO for SAP HANA – a new configuration property has been added that improves the resolution of the user principal name on the gateway side
• The on-premised data gateway now includes the May version of the Mashup Engine – the gateway will now include the same version of the Mashup engine of that of the Power BI Desktop previously released this month. Reports will now go through the same query execution as the Power BI Desktop.

 

This last point is a bit concerning. I assume queries weren't run in the same way with previous version.

 

Kind regard

 

 

Idea Statuses