Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Overview:
Merge dataflow table with a non dataflow table results in refresh error on PBI Service. PBI Desktop refresh is fine.
Steps to Reproduce:
Observed Behaviour:
Refresh fails. Below is an example of the error.
Something went wrong Unable to connect to the data source undefined. Please try again later or contact support. If you contact support, please provide these details. Underlying error code: -2147467259 Table: NonVoice. Underlying error message: The columns parameter must be null, specify the number of columns, specify a list of column names, or specify a table type. DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259 Microsoft.Data.Mashup.ValueError.Reason: Expression.Error Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net Activity ID: 83703c77-276c-43e1-83ef-9790ea382b48 Request ID: ae46f037-b1dd-9558-316e-b59540007abf Time: 2019-04-08 09:40:59Z
Expected Behaviour:
Refresh to succeed.
Workaround:
None.
Other Information:
I have attempted the following in trying to resolve;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.