I'm creating my first production dataflow, using a Pro license, and trying to add 3 customer tables from different sources and publish them (no merging, no computed tables). The tables are only lightly transformed with a filter step and removing columns. Here are my steps that end up failing:
- Adding table #1 was fine - no issues.
- When adding table #2, I clicked save & close, saw the schema validation pop-up and a loading screen...that never ends. I tried switching from Edge to Chrome, and it actually worked! So, now I have 2 tables in one dataflow.
- Tried to add table #3 in Chrome, but now getting same loading screen that never ends, just like Edge.
No error messages given...when I reload the dataflow, a pop-up says Power Query wasn't properly closed and asks if I want to try recovering unsaved changes from the cache. This results in the same loading screen and never recovers my changes.
I made sure I'm not creating any computed tables, and I have successfully saved all 3 queries as 3 separate dataflows with 1 table each...I was just hoping to keep these together for better usability. Any idea what is going on? Thanks!
