Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Folks,
I am trying to find the best way to go about doing this with PowerBi. Currently connected to our EDW which houses all the order/line item/etc information. I have a list of 30 unique sales order numbers that I want to retrieve information for that is housed on the EDW. However, my PowerBi reporting file is in directquery mode (importing all of that data would be too large).
Is there no way to Import an excel file into PowerBi, make a relationship between that dataset and the DirectQuery data set?
Maybe I am thinking about this the wrong way.
Current version of Power BI doesn’t allow to use Import and DirectQuery at the same time. If you want to retrieve information of the 30 unique sales, you need to make this list table to be in the same database which holds all the order/line item/etc information.
Please refer to here for limitations of DirectQuery. You can also vote this idea (allow Import and DirectQuery at the same time) here.
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |