Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Refresh Error: Splitter.SplitTextByCharacterTransition matches no exports

The error below is thrown when an ad-hoc or scheduled refresh is attempted. 

 

The source data is refreshing successfully and the Module references are correct.  Everything works as expected when refreshed locally in Power BI Desktop.  

 

This line splits the text from source system field names into key words by looking for changes in case (Lower->Upper). Is it possible this feature is not enabled in the portal or there's an issue with case sensitivity?

 

Code:

 

#"Split Column by Character Transition" = Table.SplitColumn(#"Renamed Columns", "Attribute - Copy - Copy", Splitter.SplitTextByCharacterTransition({"a".."z"}, {"A".."Z"}), {"Attribute - Copy - Copy.1", "Attribute - Copy - Copy.2", "Attribute - Copy - Copy.3", "Attribute - Copy - Copy.4", "Attribute - Copy - Copy.5", "Attribute - Copy - Copy.6", "Attribute - Copy - Copy.7", "Attribute - Copy - Copy.8"}),

 

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: Device Attributes - Keywords.
Underlying error message: The import Splitter.SplitTextByCharacterTransition matches no exports. Did you miss a module reference?
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Reason: Expression.Error
Cluster URI: DF-MSIT-SCUS-redirect.analysis.windows.net
Activity ID: cba3847b-b400-4d83-ae4e-18e1eb975231
Request ID: 6478fa61-1e7e-257b-a54f-e2e6c48b9c93
Time: 2019-07-08 00:53:40Z

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @derriklamb

 

From internal trace, I found the error "Too few arguments were passed to the IF function. The minimum argument count for the function is 2.", please open the report in Power BI desktop, check the calculated column "Column" in the table "[Fact] Activity", if it uses IF() function and ensure the DAX is correct. 

 

Best Regards,
Qiuyun Yu 

derriklamb
Regular Visitor

Hi Qiuyun,

 

Fixed that measure but unfortunately it didn't solve the problem. Below is the latest. 

 

I'm able to refresh locally and republish, but the portal is still throwing this error.

 

The splitter is parsing field names from Kusto, in case that makes a difference.  I'm assuming it's all just treated as text once it comes into the PQ engine.

 

Thanks,

Derrik

 

 

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: Device Attributes - Keywords.
Underlying error message: The import Splitter.SplitTextByCharacterTransition matches no exports. Did you miss a module reference?
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Reason: Expression.Error
Cluster URI: DF-MSIT-SCUS-redirect.analysis.windows.net
Activity ID: b7acb42a-423f-4584-9c90-1bcdaedfa388
Request ID: 4c58f12a-ca72-2f91-5dd2-0b4622dfc751
Time: 2019-07-09 17:47:35Z