Forum Discussion
DataFlow fails to save with Unknown Error
Hi jmg80525
Thank you for this information. Did you try to load the parameter? Based on my test, if I try to load the parameter, I have the same "UnknownError" when saving the dataflow. However if I don't load the parameter, I can save the dataflow successfully. Just keep the "Enable load" option unchecked as default and try saving again.
This is probably not an issue due to the following dataflow limitation from Dataflows considerations and limitations:
In Power BI dataflows, you can use parameters but you can't edit them unless you edit the entire dataflow. In this regard, parameters in dataflows behave similar to declared constants.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
I should have clarified that I am using the Folder connection utilizing a UNC path that contain CSV files of the same schema. It will connect fine and work through all the typical applied steps to create a query that contains all the rows from the all the CSV files. For development purposes I want to only have the last (by timestamp) CSV file in the folder. I utilize Table.LastN(Source, 1) step after the source step and this works fine. I then create a parameter (number) to contain the same value of 1 and then replace the number option with the parameter (Table.LastN(Source, pDaysToKeep). This will work in the Query Editor and I can continue to commit applied steps. However, the presence of this step with the number of rows option refering to a parameter is what keeps the query from saving.
Hi jmg80525
Thank you for this information. Did you try to load the parameter? Based on my test, if I try to load the parameter, I have the same "UnknownError" when saving the dataflow. However if I don't load the parameter, I can save the dataflow successfully. Just keep the "Enable load" option unchecked as default and try saving again.
This is probably not an issue due to the following dataflow limitation from Dataflows considerations and limitations:
In Power BI dataflows, you can use parameters but you can't edit them unless you edit the entire dataflow. In this regard, parameters in dataflows behave similar to declared constants.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Thank you! Had the same issue, found this thread, and fixed it in seconds! Kudos!
