Forum Discussion
Solved
Dataflow Connection Returns Empty Table - But the Table Isn't Empty
Hello all - I have created a dataflow in the PBIService (Premium Per User license). There are two tables within this dataflow (one gets merged into the other) so I only have the main Sales table t...
Wow. OK - I figured out the problem. I recreated the dataflow from scratch, and it turned out that a filter that worked in PowerQuery regardless of case sensitivity didn't carry across when the dataflow was used as a source. The data that I filtered on was all lowercase in the data, but my filter used Title case.
Wow. OK - I figured out the problem. I recreated the dataflow from scratch, and it turned out that a filter that worked in PowerQuery regardless of case sensitivity didn't carry across when the dataflow was used as a source. The data that I filtered on was all lowercase in the data, but my filter used Title case.