Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I'm using an ODBC connection and have a table with over 13 million rows. I only need to analyze a certain category named Rework. The preview does not load due to size of table. I can apply the row filter manually through Advanced Editor, however; it is not giving me any rows, nor is there any error! The main objective here is to reduce the refresh time. Please help! Thanks!
Code:
= Table.SelectRows(TRANSLOG_Table,each ([LOC_DESC]) = "REWORK")
Can you create another subset table of this and distinct the LOC_DESC column and see the actual value?
It keeps thinking for over an hour without a status...
Can you try with Contains and make sure it's case sensitive:
= Table.SelectRows(TRANSLOG_Table, each Text.Contains([LOC_DESC], "Re"))
It took forever to run the code, and gave me the same result as using "REWORK"
User | Count |
---|---|
79 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |