Forum Discussion

EZV12's avatar
EZV12
Helper IV
5 years ago

How to create pbix report under DirectQuery mode?

Hello everybody, I'm in trouble with DirectQuery Mode.  I need to build a report under this mode, but all funtionalities seem to be useless under this mode. I cannot creat fusions, neither add tab...
Need Help
aj1973's avatar
aj1973
Community Champion
5 years ago

Hi EZV12 

Direct Query mode has its limitations. So you either use Import mode or a mix of DQ and Import to achieve what you need. here is the difference and limitations

 

  • EZV12's avatar
    EZV12
    Helper IV
    5 years ago

    Dear Amine,

    Thank you very much for this comparaison table, however, I still have difficulties to put them into practice. Is it possible for you to share some sample files pbix under DQ mode?

    Many thanks in advance.

    Rachel

    • aj1973's avatar
      aj1973
      Community Champion
      5 years ago

      EZV12 

      Sorry but I don't think sharing files in DQ mode would help you with your issue. There are plenty of videos out there that you use to better understand. However if you expose where it's blocking for you in details I can help you better. 

       

      • EZV12's avatar
        EZV12
        Helper IV
        5 years ago

        Hello Amine,

        Here is the link https://1drv.ms/u/s!AnbNXrfr-X8jdCh4I-viYzEgvpw?e=kGjuRO for a sample file pbix. I created it by entering the data manually, but the real report is under DQ mode. Maybe you may help me to figure out some DAX formulas, which will be great! 

        Here below please some images in which I explained my problems and asked questions:

        I appreciate a lot your kind help!!

        Best regards

        Rachel