Dataflow Gen2 - Query name cannot contain the following characters: " \ / : | < > * ? '
We are looking at migrating a Power BI Legacy Dataflow to Dataflow Gen2 to take advantage of two things -
1. We can still use the existing dataset to repoint from the legacy dataflow to the dataflow gen2.
2. Use dataflow gen2 to write the output to lakehouse (instead of the legacy csv files). This will allow external teams to easily consume the lakehouse tables in other reporting tools.
But, currently we get a warning - Query name cannot contain the following characters: " \ / : | < > * ? ' when we recreate the power queries in dataflow gen2. We can currently ignore the warning but we do not know the implications. We want to keep the table names the same so as not to affect the dataset and all the visualizations built around the dataset.
I'm not sure how you are ignoring the warning - it should prevent you from saving the query name if it has invalid characters. Can you clarify that?
As far as the implications - we have this validation to prevent issues with downstream consumption due to inconsistent support for special characters. I would definitely recommend renaming the tables to exclude prohibited characters in the query names, as it will lead to other issues.