powerpoint incorrect data refresh date
I have set up daily refresh of a dashboard in Power BI service. But, when I export its report into PowerPoint. It does not show its most recent data refresh date. Instead, it seems to show the date when the report was published, not refreshed. Please fix it. Thanks.
filtered data import dynamically
Power BI desktop has an option to filter data in its Query Editor by clicking the drop down of a data column. But, sometimes, I want to filter import data based on a function. For example, I want to import only YTD records. Today, there is no way to support such dynamic filtering. It would be gre...
import data based on data model
QlikView supports this via its LEFT/RIGHT KEEP commands. Basically, if I have a Calendar and an Order tables, and the Order.Date is linked to Calendar.Date, then I would like to load only Order records with matching Order.Date and Calendar.Date. This would ensure data consistency in my data model...