Forum Discussion
CQD Dashboard data
Hello everyone,
I have successfuly connected cqd direct query connector to power BI but is there a way we can create our own measures to it ?
Please find the image below, I have created a simple measure but it doesn't allow me to get result use it.
Also notice date field is in text format when I'm trying to change, it trows an error message. If I change the mode the connecor won't work.
Can someone please help me doing above changes. If its not posible can anyone share links for documentation regarding API. Sorry I'm a newbee and trying to learn.
Cheers.
HI Nikhilganji,
Is it possible to switch to import mode to get data? AFAIK, power bi has limited the Dax function usages on direct query mode.
You can use composite mode to handle this data source: use import mode to handle the tables include records need to be calculated and others with direct query mode to keep record updates.
Use composite models in Power BI Desktop - Power BI | Microsoft Learn
In addition, power bi also shared some templates that design by power bi team with CQD data source, you can check them if help to design your reports.
Use Power BI to analyze CQD data for Microsoft Teams - Microsoft Teams | Microsoft Learn
Regards,
Xiaoxin Sheng
1 Reply
HI Nikhilganji,
Is it possible to switch to import mode to get data? AFAIK, power bi has limited the Dax function usages on direct query mode.
You can use composite mode to handle this data source: use import mode to handle the tables include records need to be calculated and others with direct query mode to keep record updates.
Use composite models in Power BI Desktop - Power BI | Microsoft Learn
In addition, power bi also shared some templates that design by power bi team with CQD data source, you can check them if help to design your reports.
Use Power BI to analyze CQD data for Microsoft Teams - Microsoft Teams | Microsoft Learn
Regards,
Xiaoxin Sheng