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.
Hello!
My .pbix file uses one datasource (Oracle Database) in Direct Query mode.
I am now trying to merge two Queries as a new one (Query Editor). The merge works as expected however when saving the changes and closing the Query Editor I get an error message stating that I can not combine direct query sources and importet sources:
Is this expected behaviour? Anything I could do about this?
Thanks!
chris
Solved! Go to Solution.
I may have found a workaround by duplicating one of the queries first and then merging with the second query. This should (in my opinion) lead to the same result as the option "merge as new query".
Still feedback from anyone who knows more about this would be very much appreciated as this error message makes me wonder...
Wow this works for me as well.
Any chance you can do the merge in the background instead? Like a materialized view since you're in Oracle?
This would be advantageous, as you'll be able to change the code in your view as many times as you want, and it will be essentially "seamless" to your report.
Gotcha. Well if it helps at all, I am constantly getting errors stating I can't combine features from DirectQuery and DirectImport types. I think it's a known limitation.
The thing is: both queries I am using are Direct Queries from the same data source. And merging them into one of them works fine. Just merging them as a new query results in this error. And as I am not importing anything I can make much sense of this error message.
So if anybody has more information on this behaviour it would be highly appreciated!
Thanks!
chris
I may have found a workaround by duplicating one of the queries first and then merging with the second query. This should (in my opinion) lead to the same result as the option "merge as new query".
Still feedback from anyone who knows more about this would be very much appreciated as this error message makes me wonder...
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |