fbpx

The Tale of Two Caches

Want to optimize performance in Power BI? Of course, you do! In order to do that, you need to understand the two caches that are at play and how they affect your optimization efforts. Marco Russo helps explain! DAX Studio 3 https://daxstudio.org Connect with SQLBI: Website: https://sqlbi.com YouTube: https://www.youtube.com/sqlbi Marco Russo: https://twitter.com/marcorus Alberto Ferrari: https://twitter.com/FerrariAlberto

The Tale of Two Caches2022-08-31T08:08:49-05:00

Merging your data in a modern lakehouse data warehouse

Learn how you can move your data through different tiers using MERGE either with pySpark or SQL in Azure Synapse Analytics. Stijn Wynants walks you through the different steps. Stijn Wynants https://twitter.com/SQLStijn pyspark.sql.SparkSession.createDataFrame https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/api/pyspark.sql.SparkSession.createDataFrame.html Table deletes, updates, and merges https://docs.delta.io/latest/delta-update.html#language-python Delta Lake Documentation https://docs.delta.io/latest/delta-intro.html

Merging your data in a modern lakehouse data warehouse2022-08-30T06:48:44-05:00

🔴 DAX Studio 3 is out! LIVE w/ Marco Russo (Aug 27, 2022)

Prioritizing questions around DAX Studio 3, optimization, performance, DAX, data modeling, processing, etc... 📢 RULES FOR Q&A: 📢 👉 Put a "Q:" in front of your comment to help us identify questions! 👉 Super chats take priority 👉 Do NOT re-post your questions! We'll get to as many questions as we can. 👉 If you [...]

🔴 DAX Studio 3 is out! LIVE w/ Marco Russo (Aug 27, 2022)2022-08-25T06:35:23-05:00

Slicers vs. Slicer Pane vs. Filter Pane! Which is faster?

You have different options in Power BI when it comes to slicers and filters. Just put the slicer on the report, use a slicer panel or have them in the filter pane. But which one is faster??? Patrick explores a few scenarios to think about! Should you hide the filter pane in Power BI? https://greyskullanalytics.com/should-you-hide-the-filter-pane-in-power-bi/

Slicers vs. Slicer Pane vs. Filter Pane! Which is faster?2022-08-25T06:22:24-05:00

Simulate Hierarchies with Field Parameters in Power BI

Struggling with field parameters and hierarchies in Power BI? They just don't work! Patrick has an approach that looks to simulate hierarchies by using field parameters in this way. Let report readers use field parameters to change visuals (preview) https://docs.microsoft.com/power-bi/create-reports/power-bi-field-parameters

Simulate Hierarchies with Field Parameters in Power BI2022-08-24T07:44:46-05:00

What is this delta lake thing?

You may be using a lake for your data and it may just be regular parquet files. In this video, Stijn joins us to explain why you should be using a delta lake instead and how this works in Azure Synapse Analytics. Connect with Stijn https://twitter.com/SQLStijn What is Delta Lake https://docs.microsoft.com/azure/synapse-analytics/spark/apache-spark-what-is-delta-lake Delta Lake Documentation https://docs.delta.io/latest/delta-intro.html

What is this delta lake thing?2022-08-24T07:46:41-05:00

🔴 100th Power BI Live Stream!!! (August 20, 2022) (Member Chat 2nd Half)

Join us live as we answer your questions about Power BI! 💥 30 minutes: Open Q&A (Public) 💥 Then... Members Only Chat (Public can watch & Super Chat for Questions) 📢 RULES FOR Q&A: 📢 👉 Put a "Q:" in front of your comment to help us identify questions! 👉 Super chats take priority 👉 [...]

🔴 100th Power BI Live Stream!!! (August 20, 2022) (Member Chat 2nd Half)2022-08-21T14:49:05-05:00

Get creative with buttons in Power BI!

Want to know how to create a button in Power BI that has an icon along with text? Adam walks you through how to set this up and to have colors sync when interacting with it. Get feedback from your Power BI report users! https://www.youtube.com/watch?v=0WfITrMl0hc

Get creative with buttons in Power BI!2022-08-18T06:23:19-05:00

Refresh and NO DATA in my Power BI visuals???

Have you published your Power BI report to the service, refresh the data, and the visuals go blank? Patrick may have an answer for you. Troubleshooting refresh scenarios https://docs.microsoft.com/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios Data types in Power BI Desktop https://docs.microsoft.com/power-bi/connect-data/desktop-data-types Damu Venkatesan: https://twitter.com/vdamu https://www.linkedin.com/in/damuvenkatesan/

Refresh and NO DATA in my Power BI visuals???2022-08-17T06:30:35-05:00

Get started with SPARK in Azure Synapse Analytics

Using Spark in Azure Synapse Analytics opens up a lot of possibilities to work with your data. Venk joins us to get you started with setting it up and quickly using data. Connect with Venk: https://www.linkedin.com/in/venkatesh-titte-4907467/ Apache Spark in Azure Synapse Analytics https://docs.microsoft.com/azure/synapse-analytics/spark/apache-spark-overview Azure Open Datasets https://docs.microsoft.com/azure/open-datasets/dataset-catalog

Get started with SPARK in Azure Synapse Analytics2022-08-16T06:31:48-05:00
Go to Top