Dataflow Connection Returns Empty Table - But the Table Isn't Empty

[a68tbird]

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 that I need to use for my dataset.  All data shows while in Power Query Online mode, and I'm able to load and refresh the table just fine. However, when I try to use that dataflow as my source connection in Excel or a PowerBI Desktop report, the table returns as empty.  I can't figure out why.  The other table within that dataflow (that got merged) shows all records within that table.  What could be preventing my Sales table from returning any records? If it makes any difference, when I edit the dataflow, and it shows the tables being used within it, the Sales table has a little lightning bolt icon on it. The other table doesn't.  That seems to be the only difference between the two tables.  They both come from the same SQL Azure database too. 

I realize this may be a very specific problem to my situation, but if anyone has any suggestions on what I can try, I would be most appreciative.

[a68tbird · Accepted solution]

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.