Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have a inline query in qliksense script now i want to load that inline query in power BI. I am new in power bi also i am done with some research but i did not find specific.. what should i do
yet i did not try any thing ,
and i have this inline query in qlik sense script .. i want to create master calendar
Let vCalStartDate = '01-Jul-2015';
Let vCalEndDate = '30-Jun-2017';
Invo_Calender:
Load
Date(Date('$(vCalStartDate)')+IterNo()-1) as %Key_Join_Date,
year(Date(Date('$(vCalStartDate)')+IterNo()-1)) as Normal_Year,
AddMonths((Date('$(vCalStartDate)')+IterNo()-1),6) as Fiscal_Date,
Month(AddMonths((Date('$(vCalStartDate)')+IterNo()-1),7)) as Fiscal_Month,
QuarterName(Date('$(vCalStartDate)')+IterNo()-1) as Fiscal_Quarter,
Year(AddMonths((Date('$(vCalStartDate)')+IterNo()-1),6)) as Fiscal_Year
AutoGenerate 1 While MonthEnd(Date('$(vCalStartDate)')+IterNo()-1) <=
MonthEnd('$(vCalEndDate)');
```
Hi @Bakhtawar ,
Currently, we cannot load a inline query in qliksense script into power bi. To be honest, I am not an expert of qliksense. I recommend to have a try of DAX function calendar.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 57 | |
| 44 | |
| 41 | |
| 21 | |
| 18 |
| User | Count |
|---|---|
| 183 | |
| 114 | |
| 93 | |
| 61 | |
| 45 |