Hi there! I am so, so excited for Power Query in Report Builder. But it seems it's not quite there yet. I used Get Data to establish a Dataset based on a query to an Oracle database. It pulls a variety of columns from a few tables, including a Site column and a Location column (each Site has many Locations). I want to be able to filter on those last two columns, so I added separate queries to my database to pull their distinct values. When I get back to the main Report Builder window, however, there is only one Dataset listed - MainQuery - and its fields are the columns from the Location query (Site and Location). Essentially it seems it takes the name of the first query, and the structure of the last, and calls it a day. If I click the "Get data" button on the ribbon and then do my query from there, it works as expected. From a user experience standpoint, and relative to Power BI specifically, it feels like the Power Query window should capture all of the "Get Data" queries, and each query should come back as a separate Dataset - rather than having each Dataset require a separate Power Query Data Source. There's another problem, though: when I try to delete the second query in my first Dataset, and then click "Create", the Power Query window just hangs as a blank white screen and never resolves. The same happens if I edit the query. An additional problem, that makes that approach not work in the first place: when I try to add a parameter for my main query, my Locations query doesn't show up as an option to draw values from (which makes sense, since it's a separate PowerQuery instance). (Also, it probably wouldn't have saved when I tried to close the window...) And if I go in and put all the queries in one Get Data Dataset - with the main query last, so its data will be accessible - I still can't access the other queries for use as parameters. --- Additionally, as a bonus bug report, whenever I go back into Power Query for this Dataset, I have to configure the settings for the main query again, every time.
... View more