How to view data in DATA tab while using DirectQuery

[Anonymous]

Hi. My PBI file combines data from a PBI dataset, and a dataflow. When I go into the DATA tab to look at the details, I can only see the content of the dataflow data. For the content from dataset, it states "This table uses DirectQuery and cannot be shown".

How can I view the dataset data? This is important information so that I can use the correct info in my analysis.

[amitchandak · Accepted solution]

@Anonymous , you can view power query and sample rows. Or create a visual and check the data there

You can log an idea for the same - https://ideas.powerbi.com/ideas/

[Anonymous]

Hi @amitchandak, do you mean I can view the data from PowerQuery? Because I tried and I can't see anything. Would like to reiterate that I am connecting direct to a Power BI dataset, not other sources like redshift or teradata (which in that case I believe you can see data from DirectQuery).