Forum Discussion
import ics file
I would like to analyse calendar data, source is Outlook 2013. I have a series of ICS files that I export every day so I can monitor changes in bookings. Fortunately, this is only for a short period ...
Which file format that you choose to import the ICS file in Power BI?
Currently there is no such an approach to import that file format. The available way from my side is:
- First convert the ICS file into CSV file format(you might need to use some ICS to CSV converter);
- Then using Power BI Desktop to Import CSV files.
As you use Outlook 2013 as the data source here, we could directly save the calendar into .CSV file format:
Open Outlook 2013, under:
File->Open& Export->Import & Export->Export to a file->Comma separated values, after that, under your mailbox settings, choose to export Calendar.
Adding some reference:
Data sources in Power BI Desktop
Data sources for Power BI service
If any further assistance needed, please post back.
Regards,
Charlie Liao