Forum Discussion
Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Hi clementskr !
See my blog post - DirectQuery gives weired queries with enormous big DAX...
Go for "Import"!
“Composite” arrived – CAUTION!
Regards
Oliver
Thanks for your reply. I pretty much always use import. However, if HR has a Power BI dataset that they have built with all of the enterprise semantic layers built into measures and likewise Finance has a Power BI dataset (both Imported on their own), and I want to tie the two together with a relationship between the two without rebuilding all of the already approved measures, which is what this feature allows me to do, I'm limited by the direct query max rows limitation of the relationship is of high cardinality. Both sources are imported in themselves but tying them together forces it to a direct query source. Obviously, a single imported dataset of a full enterprise could be made, but that seems like a maintenance and refresh nightmare.
So as far as I can tell, connecting large functional specific datasets to other large functional specific datasets isn't really enabled (depending on what that relationship is and the cardinality of such) because of direct query limitations.
- Anonymous5 years agoNot applicable
Ok, I was not aware that also there are limits when the direct is to an tabular in memory...
I also had some other issues to connect datasets.
See:
Stacked datasets