Dataflow gen2 will not publish - but query preview does not indicate an error

[KylePerkins]

I have a Dataflow Gen2 that will not publish new changes to its queries dispite the query preview not indicating any errors. The Dataflow had previously published, but after adding additional data sources and query steps (all of which are functioning and can publish) it no longer will publish. I've rewritten query steps and used the standard queries generated by Power Query, both of which could be previewed without errors, but in either case the Dataflow will not publish. The data sources are other Dataflows which are connected to Sharepoint folders containing csv files, all of which can be edited and republished successfully. Any ideas on where to start troubleshooting from here?

[v-shamiliv]

Hi @KylePerkins 
Could you please let us know if your issue has been resolved? If so, kindly mark the helpful reply and accept it as the solution. This will assist other community members in resolving similar problems more quickly.
Thank you.

[v-shamiliv]

Hi @KylePerkins 
Could you please let us know if your issue has been resolved?.If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-shamiliv]

Hi @KylePerkins 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-shamiliv · Accepted solution]

Hi @KylePerkins 
Thank you for reaching out microsoft fabric community forum.
The workspace list should provide a more detailed error message, indicating why the publish has failed. Additionally, could you share a screenshot of the error?
Thank you

[nilendraFabric]

Hello @KylePerkins 

Please give these options a try :

Clear Power Query Cache:
Go to File > Options and Settings > Options > Data Load in Power BI Desktop. Clear all caches under the “Data Load” section

If possible, try disabling the staging option for your dataflow. 

last option would be try creating a new dataflow and importing your existing queries into it

see if this helps. 

please give kudos and accept the solution if it is helpful 

thanks

[KylePerkins]

I'm working entirely in powerbi Service. There is no option for "file" and the data load options do not have a clear cache option.