The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi,
Is there a way we can find the number of rows in each table in the Power BI data model? And also the refresh times of each tables?
Where is the metadata saved for each model?
thanks in advance.
Solved! Go to Solution.
Hi @PBIfanatic ,
You could find total rows in the lower left corner of the data tab.
As for refresh times, you could find it from refresh history in Power BI service.
Hi @PBIfanatic ,
You could find total rows in the lower left corner of the data tab.
As for refresh times, you could find it from refresh history in Power BI service.
You can refer this for PowerBi meta data
https://community.powerbi.com/t5/Desktop/power-bi-metadata/td-p/335671
For rows, you can use countrows(Table)
User | Count |
---|---|
65 | |
61 | |
60 | |
53 | |
27 |
User | Count |
---|---|
181 | |
83 | |
68 | |
49 | |
46 |