Analyzing Customer Bookings via PBI

JulianVolmert · ‎12-30-2022

Hi Team,

I was browsing the forum but were not able to find an answer to my question. We have just recently implemented microsoft bookings and I would like to run some analysis on our customer visits (where are they from, how often did they come by, etc.). However, when I connect PowerBI with bookings, I can only see the name of the customer but not there location anywhere? Is there an easy way to pull this data out from bookings and into PBI?

Thank you for your support!

arock-well · ‎07-12-2023

I can't answer your specific question. But, how are you connecting to Bookings? We're starting to use Bookings and will eventually like some reports in Power BI connected to it.

lbendlin · ‎01-01-2023

Looks like at the moment they only support "TSV" files (CSV with tabs instead of comma as the field separator) which you can read into Power BI via the Text connector.

View Bookings calendar information | Microsoft Learn

This thread may be of interest: https://powerusers.microsoft.com/t5/General-Power-Automate/Problem-with-Microsoft-Bookings-calendarV...