Forum Discussion
Access tables from a Direct Query Dataset in a Blank Query
I'm trying to work out if it's possible to access Tables that exist within a Power BI dataset that is using Direct Query from another Query. Steps so far: * New Power BI Desktop Report * Add Po...
GrantTrevor , the Power bi dataset will come as full. And you can do changes or view script as of now.
You can try dataflows, in case you want access tables separately. But dataflow is not a model, just a set of tables in service.
Thanks amitchandak for that response.
I'm not trying to alter the tables in the direct query dataset instead what I would like to achieve is to create a new Table that pulls in data from that Direct Query Dataset but have that table only be present in the Report I'm authoring.
This would mean the Report uses two DataSets
* one pulled in via Direct Query
* one that is for this Report only and it contains a Table that pulls/transforms data from the other one.