QQUBE to PowerBI Setup - Can you make month to month Budget to Actuals?

[CPATechNoob]

Hi There,

I'm working on evaulating QQUBE and Powerpoint. One thing I noticed is out of the box I am not able to query or pull specifc months out of the QQUBE database. Is it possible to build a month to month Budget vs. Actual report into PowerBI? This is a common request from management and we currently build this now manually via excel. All I see in the QQUBE database is current month, previous month, current quarter, previous quarter, current year, etc.

[v-yuta-msft]

Hi CPATechNoob,

In your senario, I would recommend you can use ODBC connnector and write some SQL statement to pull the specific record to power bi.

Regards,

Jimmy Tao