Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I have a imported set of tables combined to a data model and query / charting the data which I need.
So far so good, I’m really impressed with Power BI.
To make the solution more productive I plan to import the same set of Tables (which already in data model) every week and query 7 charting the changes over the time.
Since the original database (where the data came from) have no issue date, I need a capability to indicate when the record was valid.
This would provide a 2 detention time model for reports like “We improve the numbers of xxx over the time of xx weeks about 40%” etc.
My plan is to have I additional time stamp / Date field with each table, when the record was imported into Power BI database.
So my 2 questions for this scenario are:
Just to let you know, I’m working only with PBI desktop
Cheerio
Gregor
Solved! Go to Solution.
Last Refreshed = DateTime.LocalNow()It will change once your refresh your dataset. For more details, please refer to links below:
SELECT * FROM $System.MDSCHEMA_CUBES
Regards,
Last Refreshed = DateTime.LocalNow()It will change once your refresh your dataset. For more details, please refer to links below:
SELECT * FROM $System.MDSCHEMA_CUBES
Regards,
thanks Simon,
work perfect:)
BR
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |