Forum Discussion
Post ProdigyWhat-IF scenario in Direct query
Hi,
I'm wondering what is the workaround for What-If scenarion in Direct Query ?
Since GENERATESERIES will create new table and that is not allowed. Or is it the only way is to create a single table contain the numbering in the source database ? Is there other that can be achieved inside Power BI it self.
Thanks
admin_xlsior , pure direct query means it needs to be in the Database. Power Query table is also power bi local table
3 Replies
- amitchandak
Super User
admin_xlsior , Direct query should work with generateseries table. composite mode.
I was able to use power bi date table with direct query: https://www.youtube.com/watch?v=cQfJ0GmQ5os&list=PLPaNVDMhUXGbKatyDdOhGbTL3xW2Xy6pA&index=7
admin_xlsiorHi amitchandak ,
Yeap, however I need to use "pure" Direct Query.
Is there someway, I can use the GENERATESERIES like in M Language maybe. I'm not sure, I just giving some 'crazy ideas'.
Else I can create it from my source DB (SQL)
Thanks
Thanks,
- amitchandak
admin_xlsior , pure direct query means it needs to be in the Database. Power Query table is also power bi local table