Forum Discussion
Disappointed with Dataflow Gen2
I have found that Dataflow Gen2 which uses Power Query doesn't work the same way that Power Query in Power BI and Microsoft Excel. It times out when previewing or refreshing if the query doesn't comp...
I believe there are many reasons to be upset with Dataflow Gen 2 (losing credentials, query limits, staging issues, mashup issues, deployment pipeline issues, lack of git integration, excessive use of CU to name a few), but spaces in column headers really should not be the straw breaking the camel's back! Keep in mind that your lakehouse will not allow for spaces in column names or table names. So you will need to address this with or without using Dataflows.