It’s no secret that I think Power BI is great, even on days like today when Power BI has well and truly shafted me. Half the day has been lost by crashes and everything is getting tense, but still Power BI is going to deliver. The biggest challenge you’ll face with Direct Query is that it is only able to do a subset the things that your normal “full fat” Power BI deployment can do. As you no doubt read in my other post “A Plan Forms” lots of businesses will like Direct Query, certainly as a day one proposal when starting in Power BI.
Once you start down the Direct Query route be prepared to consider that you have to make sure there’s plenty of headaches on the road to victory. Undertaking it though is well worth it. I will continue to keep you informed of my progress and you can sneer at my mistake and hopefully we can have some thigh slapping moments together.