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.
Everyday I get a report that shows me all orders that are shipping late. The report data is coming in via Exchange connector and with every refresh a new report replaces the old report daily.
One of the measures I have to present is a simple total unshipped count. I've accomplished this by doing using CALCUALTE(DISTINCTCOUNT(etc... This number shows up on a tile visual in the report.
I'm being asked if there is a way to have Power BI record this daily changing number (refresh from a new report everyday at 5:00 AM) so we can build up a historical database to see which of our shipping locations are struggling to keep up with shipment fulfillment.
The new output table would look like this.
Date of count | Inbound or outbound | Plant | Total count for day |
7/9/20 | IN | Milwaukee | 7 |
7/10/20 | IN | Milwaukee | 4 |
7/11/20 | OUT | Milwaukee | 6 |
etc...
I could then use this daily updated and generated table to create a line graph visual to show daily progress for inbound and outbound shipments for plants with the goal to have 0 total count for each day.
Solved! Go to Solution.
Hi @Mike-Hydrite ,
As you said, refresh will override the old dataset.
You can consider creating a dataflow and setting it to an incremental refresh.
https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-create-use
https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-data-sources
https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-incremental-refresh
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Mike-Hydrite ,
As you said, refresh will override the old dataset.
You can consider creating a dataflow and setting it to an incremental refresh.
https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-create-use
https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-data-sources
https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-incremental-refresh
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
114 | |
100 | |
78 | |
75 | |
50 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |