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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Analitika
Post Prodigy
Post Prodigy

Table in data preview differs than in transform data

Hello,

 

I would like to ask why same table differs in data preview and in transform data in Power BI?

 

Analitika_0-1629437545661.pngAnalitika_1-1629437609717.png

First picture represent Parinkimas 2 table in transform data and second picture represents Parinkimas 2 table in data preview.

Parinkimas 2 in same report. What's the problem that it differs?

 

Analitika_0-1629438742355.png

I made filter from Parinkimas 2 see just one option, instead of three.

2 REPLIES 2
Analitika
Post Prodigy
Post Prodigy

Seems no answer.  What questions are from yours side?

Anonymous
Not applicable

Hi @Analitika 

Normally, table in Power Query Editor (transform) and in Data view should be the same.

Please check whether you did some filter on your table in Power Query Editor.

In my Power Query Editor:

2.png

In my Data view:

1.png

If this reply still couldn't help you solve your problem, please share a sample without sensitive data with me by Onedrive for Business. What kind of data source did you get data from? What is your connection mode, Import or Direct Query?

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.