Forum Discussion

sotoc's avatar
sotoc
Advocate I
7 years ago
Solved

Simple Workarounds for Direct Query Limitations

I am fairly new to Power BI and am requesting a reference or tips on how to workaround the Direct Query limitations, as I've only used Import thus far. The very simple description from MSFT here is n...
Need Help
Tips and Tricks
Tutorial Requests
  • RMDNA's avatar
    RMDNA
    7 years ago

    Hi sotoc,

     

    There really aren't many workarounds - needing to do those kinds of operations is exactly why you would use Import rather than Direct Query. What are the constraints to you using Import?

     

    If changing isn't an option, make your transformations in the datasource so that everything you need is available once you've connected by DQ.

RMDNA's avatar
RMDNA
Solution Sage
7 years ago

Hi sotoc,

 

There really aren't many workarounds - needing to do those kinds of operations is exactly why you would use Import rather than Direct Query. What are the constraints to you using Import?

 

If changing isn't an option, make your transformations in the datasource so that everything you need is available once you've connected by DQ.

  • sotoc's avatar
    sotoc
    Advocate I
    7 years ago

    Thank you RMDNA.  Unfortunately I am bound to  Direct Query only with a single table per report. They will only pull the rows for me, they won't conduct any transformations in the source data. 

     

    Any idea when the composite model  will be officially launched for the service? We are going to embed our report after I create in the desktop so I can't create the report in the preview version yet.