Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply

Is there a way to view download/view dataset

Hello,

I have just did some merging and of data sources and would like to view the whole data that set.

For instant, like a pivot table from excel where i can drill into the values and look at the data.

 

is there any features like this in powerBI? 

Reason for asking is because i want to see if i am churning the correct data.

 

Thanks in advance 🙂 

1 ACCEPTED SOLUTION

im still not sure if in power query , you have the records tab if in dax then you can create a matrix table that is like a pivot table

View solution in original post

4 REPLIES 4
KJoshi
Regular Visitor

Hello,

 

I believe you want to see what it looks like for each row in Power Query editor window.

After merging the data, you would see something like below:

KJoshi_1-1691757651089.png

 

You can click on the blank space besides the word "Table" to view the contents. You can even expand this using the following Icon besides the column name.

KJoshi_2-1691757782782.png

 

Do let me know if this is what you are looking for.

 

Regards,

KJ

eliasayyy
Super User
Super User

hello can you please explain better

For instance, in excel, we can double click on the value to look into the raw data.
Would there be such a way in powerBI? 

Sorry if i am unclear!! Thanks in advance!!!

im still not sure if in power query , you have the records tab if in dax then you can create a matrix table that is like a pivot table

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.