Forum Discussion
Error when filtering visual in Composite Model
Hi thegekko42,
Please take limitations below as a reference:
When connecting to those multidimensional sources using DirectQuery, you cannot also connect to another DirectQuery source, nor combine with imported data.
The existing limitations of using DirectQuery still apply when using composite models. Many of those limitations are now per table, depending upon the storage mode of the table. For example, a calculated column on an imported table can refer to other tables, but a calculated column on a DirectQuery table is still restricted to refer only to columns on the same table. Other limitations apply to the model as a whole, if any of the tables within the model are DirectQuery. For example, the QuickInsights and Q&A features are not available on a model if any of the tables within it has a storage mode of DirectQuery.
Regards,
Jimmy Tao
Hi thegekko42,
Please take limitations below as a reference:
When connecting to those multidimensional sources using DirectQuery, you cannot also connect to another DirectQuery source, nor combine with imported data.
The existing limitations of using DirectQuery still apply when using composite models. Many of those limitations are now per table, depending upon the storage mode of the table. For example, a calculated column on an imported table can refer to other tables, but a calculated column on a DirectQuery table is still restricted to refer only to columns on the same table. Other limitations apply to the model as a whole, if any of the tables within the model are DirectQuery. For example, the QuickInsights and Q&A features are not available on a model if any of the tables within it has a storage mode of DirectQuery.
Regards,
Jimmy Tao
Thanks for the feedback Jimmy
My issue was that I had 2 matrixes pulling data from the same DirectQuery.
They were both connected to a slicer which pulled data from a table created directly in PowerBI
the
If they both failed I could understand it and your explanation would comepletly explain my problems.
But one matrix worked perfectly with the slicer, whereas the other failed with the slicer.
Your comment did make me rethink the setup of the model though.
For the pages with the failed visuals, I could actually pull the date info from the same table as the matrixes pull their data from.
So my problem was solved for now, though I still don't quite understand how it did not work in the first place.