TGViewer
Data Analytics Data Analytics @sqlspecialist · 111K subscribers
Post #2699 6.12K
18. What is data blending in Power BI? 
Data blending (sometimes confused with “merge”) usually refers to combining fields from multiple tables at the visualization level, often via relationships or calculated columns/measures rather than ETL-level joins.

19. How do you optimize large datasets? 
• Use a star-schema model, avoid unnested structures.
• Use appropriate data types, remove unnecessary columns.
• Prefer measures over large calculated columns, enable incremental refresh, and push heavy filters to the source when possible.

20. What is Get Data? 
“Get Data” (in Power BI Desktop) is the Power Query interface that lets you connect to various sources (SQL, Excel, Web, etc.), load, and transform data into the model.

Double Tap ❤️ For More
  • ❤ 11
More from @sqlspecialist
  1. Oct 9, 2026“Here, the data is sorted by the second column in descending order and the first five rows…
  2. Oct 9, 2026📊 Data Analyst Interview Series — Part 6 Guys, let's continue our Data Analyst Interview…
  3. Oct 9, 2026🇮🇳 𝗚𝗢𝗩𝗘𝗥𝗡𝗠𝗘𝗡𝗧 𝗢𝗙 𝗜𝗡𝗗𝗜𝗔 — 𝗔𝗜𝗖𝗧𝗘 𝗜𝗡𝗧𝗘𝗥𝗡𝗦𝗛𝗜𝗣𝗦 𝟮𝟬𝟮𝟲 🚀…
  4. Oct 8, 2026🎓 𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝗙𝗥𝗘𝗘 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝘄𝗶𝘁𝗵 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗲𝘀! 🚀🔥 Upgr…
  5. Oct 7, 2026📊 Kandinsky 6.0 Video: AI-Powered Content Creation for Analysts The new Kandinsky 6.0 Vid…
  6. Oct 7, 2026Alternatively, depending on the Excel version and requirement, I could use functions such…
Threads Profile ViewerView any public Threads profile without an account.Open ThreadLook →Writing with AI? Make it sound human.Metric37 rewrites AI drafts so they read naturally. Free AI detector, 1,500 words free.Try Metric37 →