Forum Discussion
How to create pbix report under DirectQuery mode?
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
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.
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
Ok, am gonna answer your issues picture by picture.
Picture 1 :
The answer is no, you can't group 2 tables under DQ mode nor Use DAX( it is considered as a Complex DAX functions, check the table). If you want to use DQ in this case then add a view to your data base where you group these 2 tables then upload it to your Model as DQ mode. DQ utilise un connection directe a la BD, donc le model et les tables sont déjà en place.
Picture 2 :
1) I don't see why you are not able to connect the 2 tables!!! I think you can but it is Many to many relationship which is not recommended.
2) I will get back to you on it if it is really neccessary...
Picture 3 :
Wrong, the tables can be connected, le message est claire: c'est juste la relation est de cadinalité plusieurs à plusieurs qui est pas recommandé dans un model Power Bi. Donc la relation est possible mais aussi vous pouvez utiliser DAX pour avoir la formule qui vous convient dans vos calcules.
Picture 4 :
I the picture, you have tables that are in DQ mode connections, Import Mode and Live connection mode. Those "strange" links indicate the difference between the connection mode of the tables. Why would you want to replace them by DAX!!!
Je sens que il y a beaucoup de chose qui ne sont pas claire pour vous. le Data Modeling in Power Bi est l'étape la plus critique. You need to know from the get going, who and how the user is going to use your report? Why chosing DQ mode vs Import mode!? benefits and limitations!? Am I going to use Time intelligence? What tables do I need for DQ and for what! if no need then Import mode is the best Option. Why not using Dataflow for example!? Performance?...and many other Questions that need to be answered before jumping into developping a report.
Collecter des informations utiles et comparer le Use of Import mode vs DQ mode can save you a lots of time.
Hello Amine,
Thank you for your reply that helps me clarify several points. However, as I'm a beginner in PBI, I need some help to figure out some DAX formulas mentioned in my questions.
If you can help, it would be great.
Best regards
Rachel