Teo on 21 Dec 2014 22:55:52
It appears that the Designer Preview always imports data. Please give a choice between caching and direct queries.
Administrator on 18 Mar 2021 19:03:32
Use DirectQuery in Power BI Desktop - Power BI | Microsoft Docs
- Comments (4)
RE: Direct Queries
I have the same problem with ORACLE connections. my 3 mil query need 3 hours to update, and its bothersome when you just change a datype or add a calculated column, which doesn't need reread the source data. There should be a clear separation between the data that needs to be fetched and the mutations that should be done to that data.
An alternative could be to be able to manipulate the query in the powerbi com. Loading in powerBI .com this would enable met to develop with subsets and load the full data after I published it.
RE: Direct Queries
Is this still planned? Not being able to connect live to SSAS MOLAP models is a big problem for us. Excel can do it...
RE: Direct Queries
Will multi dimensional be added as well for live data conectivity in the Designer?
RE: Direct Queries
But it's not just SSAS, Will. Sometimes, it just doesn't make sense to import all that data. I hope the SSAS team is working on removing the DirectQuery limitations.