Power BI - What You Need to Know About Direct Query

  Рет қаралды 18,000

Pragmatic Works

Pragmatic Works

Күн бұрын

Пікірлер: 20
@alchandeck6471
@alchandeck6471 Жыл бұрын
Man I love the energy and enthusiasm with which you are teaching Power BI. This is my first time watching a video about Power BI and I was engaged and understood most of it. I gotta say I come from a two-year Data Engineering professional experience with AWS, but not PBI, so that definitely helped. I wanted to recommend you introduce pre-requisites slide at the beginning of the presentation. You can even point them to your previous videos (increase your views per video) explaining the pre-requisite topics :). Keep up the great work! You've earned a new sub :)
@praveenkumar_9143
@praveenkumar_9143 Жыл бұрын
One of the Excellent video I have seen on KZbin [ diff b/w Import and DQ ]
@houstonvanhoy7767
@houstonvanhoy7767 2 жыл бұрын
Nicely done, very informative. I look forward to the rest of the series.
@PragmaticWorks
@PragmaticWorks 2 жыл бұрын
Awesome, thank you!
@MagicNumberArg
@MagicNumberArg 3 жыл бұрын
It's true that a lot of Dax functions are not available, but you do have access to raw SQL, with all its transformations, including UDF 😉
@SolisRx
@SolisRx 3 ай бұрын
Excellent job Manuel! Thanks
@emilyamalkin4367
@emilyamalkin4367 Жыл бұрын
Excellent overview! Thank you! Where are the other related videos? (The 2nd video on Composite Mode)
@joseluisbeltramone599
@joseluisbeltramone599 2 жыл бұрын
Great and useful video! Muchas gracias, Manuel 🙂
@PragmaticWorks
@PragmaticWorks 2 жыл бұрын
Glad you enjoyed (:
@javedabdool1187
@javedabdool1187 Жыл бұрын
great video. on pbi desktop in order to get the real time data we need to refresh the page so in that sense how does it differ to import mode?
@manuelquintana2225
@manuelquintana2225 Жыл бұрын
For Direct Query Connections there is no refresh required. As users interact with the report they are always looking at the live data from the source system. When you choose the import option for a connection you are storing all the data in the local power bi model. This means you will have to schedule a refresh through the Power BI service in order to see any updated information from the source. Basically in an imported model, users only see that data that is currently loaded into the power bi report. If there are new records and updates in the source system they will not be seen in the power bi report until you schedule and run a refresh.
@javedabdool1187
@javedabdool1187 Жыл бұрын
@@manuelquintana2225 many thanks Manuel...but issue is lets say i have a query with column name and age the first time the query is sent to the source but afterwards if you execute same query it won't bring new data as the previous result is cached in the visual so you have to refresh it to get new data like import mode.
@yashpisat9267
@yashpisat9267 Жыл бұрын
Great Video! thank you for the video. I have a doubt: I have defined relation between two tables in Direct query mode. But when I try to filter anything, it works in singe mode. Whenever I try to filter out something from another table, it does not work. I tried to change the option to both ways filter, that way it throws an error and visuals are not loaded! what can I do in such case.
@srgsrg762
@srgsrg762 Жыл бұрын
Hi - Many thanks for spreading this amazing informative video. I have a question though. If I make changes to table info in SQL server db after connecting to Power BI, will this change reflect in Power BI automatically ? if not, how can I see my changes made, for eg added a new column . Ta
@phorton968
@phorton968 3 жыл бұрын
Great KZbin. Manuel made it easy to follow material. I got a lot out of it. Thanks much!
@PragmaticWorks
@PragmaticWorks 3 жыл бұрын
Glad you enjoyed it!
@Terra8622
@Terra8622 2 жыл бұрын
Incredibly informative! Thank you
@PragmaticWorks
@PragmaticWorks 2 жыл бұрын
Glad it was helpful!
@kailasswami3319
@kailasswami3319 2 жыл бұрын
Hey, I have one query.. I have published the report with dataverse as a source and direct query mode. but my end users are not having access to dataverse....hence reports is showing with visual errors at their end...what should be done in order to let them see the report data.
@rn4341
@rn4341 2 жыл бұрын
Thank you for this Manuel
Split Columns Into Rows - Power Query Editor Tips and Tricks
8:09
Pragmatic Works
Рет қаралды 7 М.
Unboxing new Power BI composite models
23:38
SQLBI
Рет қаралды 76 М.
VIP ACCESS
00:47
Natan por Aí
Рет қаралды 25 МЛН
Speed up Power BI development time with filters and parameters
11:20
Pragmatic Works
Рет қаралды 5 М.
Hands-On Power BI Tutorial 📊 Beginner to Pro [Full Course] 2023 Edition⚡
3:02:18
Understanding Power BI Licensing (Capacities)
16:57
Pragmatic Works
Рет қаралды 16 М.
PBIMCR - Direct Query with Chris Webb
1:02:52
Ben Howard (PowerBI specialist)
Рет қаралды 9 М.
DAX Filter Context Basics [Full Course]
1:26:25
Pragmatic Works
Рет қаралды 70 М.
Power BI Workspaces and Security Roles
18:35
Pragmatic Works
Рет қаралды 14 М.
Power BI Composite and Hybrid Models
50:51
SQLBits
Рет қаралды 4,6 М.
Power BI Get Data: Import vs. DirectQuery vs. Live (2021)
8:31
Guy in a Cube
Рет қаралды 324 М.