Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I encountered the following error in Dataflow (Gen2). The source is on-premises Oracle, and both table names and column names are in Korean. Is it not possible to use Dataflow with DB objects that have names in Korean?
There are no results for query_WriteToDataDestination: Mashup Exception Expression Error Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: An error occurred while creating the Lakehouse table in the version. Basic error: The table can only contain uppercase or lowercase letters, numbers, or underscore characters. Details: Reason = Expression.Error;Message = The table can only contain uppercase or lowercase letters, numbers, or underscore characters.;Message.Format = The table can only contain uppercase or lowercase letters, numbers, or underscore characters.;Microsoft.Data.Mashup.Error.Context = User GatewayObjectId: e812cb4a-c1e2-4849-ba3e-4d5a0808c9fb
Solved! Go to Solution.
Hi @JoopKim
Thanks for using Fabric Community.
The error message states that the Lakehouse table can only contain uppercase or lowercase letters, numbers, or underscore characters. This limitation is likely causing issues with your Korean table and column names.
Unfortunately, Dataflow Gen2 currently has limitations regarding non-ASCII characters (including Korean characters) in table names. The table names must adhere to the alphanumeric and underscore convention (uppercase or lowercase letters, numbers, or underscores). As a result, using Korean table names directly may not be possible within Dataflow Gen2.
Possible Workarounds:
While direct use of Korean table names might not be feasible, consider the following workarounds:
Hope this helps. Please let me know if you have any further questions.
Your help has been greatly appreciated. I am glad to have identified the cause clearly. I should consider using alias instead of rename. Thank you for your diligent response.
Hi @JoopKim
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.
Hi @JoopKim
Thanks for using Fabric Community.
The error message states that the Lakehouse table can only contain uppercase or lowercase letters, numbers, or underscore characters. This limitation is likely causing issues with your Korean table and column names.
Unfortunately, Dataflow Gen2 currently has limitations regarding non-ASCII characters (including Korean characters) in table names. The table names must adhere to the alphanumeric and underscore convention (uppercase or lowercase letters, numbers, or underscores). As a result, using Korean table names directly may not be possible within Dataflow Gen2.
Possible Workarounds:
While direct use of Korean table names might not be feasible, consider the following workarounds:
Hope this helps. Please let me know if you have any further questions.