Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
@Anonymous
Back to your initial question. Yes. you can query OData and get row counts. Add a custom column and run this function against your feed.
Table.RowCount([Data])
N -
Does this happen before the Odata load? Can you filter the function?
@Anonymous
Yes, you get the row count on the binary image - all those tables are not physically loaded into the model. Not sure what do you mean by "Can you filter the function?"
N -
@Anonymous,
What OData service do you connect to? Do you add select and filter parameters in the OData URL to limit the imported rows?
Regards,
Lydia
Yes to both. At this point, I'm only downloading the data I need. I did realize after I posted this that I can group the results which helps, but it would be really nice to do this before the data gets into BI to further improve performance.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |