Top Tweets for #DirectQuery
Today, I discussed an important #Performance consideration for #PowerBI, which is due to #DirectQuery. I explained why and how it impacts, as well as the myths and misconceptions associated with its use.
Watch the video here:
https://t.co/KVr0jwaEKt
#MicrosoftFabric #PerformanceTuning #ImportData #DataAnalytics #Analytics #BusinessIntelligence #DataVisualization #BigData
Today, I discussed an important #Performance consideration for #PowerBI, which is due to #DirectQuery. I explained why and how it impacts, as well as the myths and misconceptions associated with its use.
Watch the video here:
https://t.co/nqBXEWMuNL
#MicrosoftFabric #PerformanceTuning #ImportData #DataAnalytics #Analytics #BusinessIntelligence #DataVisualization #BigData
When dealing with large semantic models, incremental partition refreshing is key. Reloading the whole thing at once can cause backend systems to fail. Also, direct query can cause visuals to break if the SQL server pauses. #semanticmodels #directquery https://t.co/27JzcqemmE
🚀 Check out my latest video on how to integrate #PowerApps with #MicrosoftFabric Warehouse and enable writebacks for #PowerBI reports using #DirectQuery or #DirectLake models! https://t.co/EkvTNFKAlD
Honestly, DirectQuery is for the rich!
Set your expectations right.
You cannot optimize DirectQuery to perform like Import mode.
#Honestly #powerbi #directquery
The second edition of 𝗢𝗽𝘁𝗶𝗺𝗶𝘇𝗶𝗻𝗴 𝗗𝗔𝗫 𝗶𝘀 𝗰𝗼𝗺𝗽𝗹𝗲𝘁𝗲.
𝟰𝟬 𝗵𝗼𝘂𝗿𝘀 of video lectures.
𝟴𝟬𝟬 𝗽𝗮𝗴𝗲𝘀 in the book.
𝟮 𝘆𝗲𝗮𝗿𝘀 of work.
Now it's your turn.
You're welcome.
#dax #optimization #vertipaq #directquery
Read more: https://t.co/0grvMOg16T
#PowerBI #DirectQuery n00b question help:
• When building a thin report on a Direct Query model, is it better/optimal to use slicers on the canvas or filters on the filter pane?
I believe @cwebb_bi , you mentioned in a YT vid the latter is recommended, if im not mistaken?
#PowerBI #Snowflake #DirectQuery
Two identical Power BI reports. One has a main FACT table imported (9 months data 45M rows). The other access the same data via Direct Query to Snowflake.
DQ is stunningly performant!
And largely I don't have to worry about PBI refresh!
✨One thing you might not have discovered in #PowerBI #DirectQuery connectivity mode is that when you connect to tables in different databases, each of the database tbls are color-coded at the top! In this screenshot, 5 tables from different databases were provisioned in the PBI
This article+video describes how to optimize time intelligence calculations with DirectQuery over SQL in Power BI by avoiding time intelligence DAX functions.
#dax #powerbi #directquery
https://t.co/pjWVRyPL5d
Live Connection Mode:
It is similar to #DirectQuery but is typically used for Analysis Services models or Power BI datasets hosted in #PowerBI service
It enables you to create reports & dashboards that connect to an existing data model without importing or replicating data
2) DirectQuery Mode:
In #DirectQuery mode, Power BI sends queries to data source(DS) in real-time
Data remain in source system & Power BI retrieve & display it as needed
This mode is suitable for large datasets or when you want to maintain a live connection to your data source
#PowerBI #DirectQuery is an essential tool for those dealing with extensive #data, providing real-time reporting without requiring pre-aggregation. Let's explore its advanced functionalities and examine how they can be harnessed to tackle complex data challenges. 🔗 https://t.co/g4iEGmxGPz
Today @Rad_Reza explained in my latest article and video;
What is #PowerBI #DirectLake mode, and how it works with the #Microsoft #Fabric object like #Lakehouse
read or watch here: https://t.co/t51DSM5TDJ
#RADACAD #MicrosoftFabric #ConnectionTypes #DirectQuery #ImportData
Today I explained in my latest article and video;
What is #PowerBI #DirectLake mode, and how it works with the #Microsoft #Fabric object like #Lakehouse
read or watch here: https://t.co/HhxWNe9Zd3
#RADACAD #MicrosoftFabric #ConnectionTypes #DirectQuery #ImportData
@cwebb_bi on #PowerBI #DirectQuery mode that’s worth a watch especially if you work with any of the #bigdata sources such as #Synapse #Snowflake or #databricks @mspowerbi @mspowerquery https://t.co/2pt9bQeow1
Many businesses struggle with better #performance for their #PowerBI datasets, even when leveraging the cloud.
Today I'll show you how to get the best performance with #DirectQuery for #PowerBI datasets and Azure Analysis Services 🧵👇
[New Blog Post] Parquet, CSV or SQL with PowerBI https://t.co/Id7vztOGsl #powerbi #sql #parquet #import #directquery #performance
![ReviewMyDB's tweet photo. [New Blog Post] Parquet, CSV or SQL with PowerBI https://t.co/Id7vztOGsl #powerbi #sql #parquet #import #directquery #performance https://t.co/jlPxo8Adnu](https://pbs.twimg.com/media/Fp_wirBWIAAPMU0.png)
Fast, efficient and live data access from Microsoft Power BI through DirectQuery connections to SAP Data Warehouse Cloud - learn more https://t.co/AmlEYoIGRn
#SAPStore #SAPDWC #SAPDataWarehouseCloud #directquery #PowerBI #APOSLiveDataGateway #SAP #cloud #sapcommunity
Most Popular Users
Elon Musk 
@elonmusk
240.2M followers
Barack Obama
@barackobama
119.3M followers
Donald J. Trump
@realdonaldtrump
111.6M followers
Cristiano Ronaldo
@cristiano
108.9M followers
Narendra Modi
@narendramodi
107M followers
Rihanna
@rihanna
97.3M followers
NASA
@nasa
92.1M followers
Justin Bieber
@justinbieber
90.6M followers
KATY PERRY
@katyperry
86.8M followers
Taylor Swift
@taylorswift13
80.6M followers
Lady Gaga
@ladygaga
72.2M followers
Kim Kardashian
@kimkardashian
69.4M followers
YouTube
@youtube
68.6M followers
Virat Kohli
@imvkohli
68.5M followers
Bill Gates
@billgates
63.4M followers
The Ellen Show
@theellenshow
62.5M followers
CNN
@cnn
61.9M followers
Neymar Jr
@neymarjr
61.1M followers
X
@x
60.9M followers
Selena Gomez
@selenagomez
59.9M followers