Power Query in Azure Data Factory does not seem to recognize the range in a dataset
Sjef van Zwet
1
Reputation point
I have defined an Excel file as dataset with a specific range. However when using this dataset in Power Query for data wrangling, it is not recognized. BUT if you create an Power Query activity in a pipeline and execute this pipeline, the range is taken into account. This means at design time Power Query gives a different result than at runtime.
I have worked around that by designing after deleting the first rows, but before publishing remove that step. Is it a know bug or am I doing something wrong?