Forum Discussion
Chart for Calendar Weeks Data same like in Excel
Hi Anonymous ,
After you update the Excel file, you can either manually refresh the table from Power BI side or set up a Data Gateway. After each data refresh, the unpivoting and other operations will happen automatically. You can read more about data refresh here (https://www.c-sharpcorner.com/article/what-is-data-refresh-in-power-bi-and-how-to-set-up-schedule-refresh-in-power-bi/)
Regards,
Aditya
Hello,
Thanks for sharing and replying 🙂 It is looking how i imagined it. But i have one more question. Will unpivoting and converting happen automaticly each time i will update the Excel file? This is important to me as well.
BR
Wojciech
Hi Anonymous ,
After you update the Excel file, you can either manually refresh the table from Power BI side or set up a Data Gateway. After each data refresh, the unpivoting and other operations will happen automatically. You can read more about data refresh here (https://www.c-sharpcorner.com/article/what-is-data-refresh-in-power-bi-and-how-to-set-up-schedule-refresh-in-power-bi/)
Regards,
Aditya