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 :)
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
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.
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.
@@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.
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.
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 :)
wow ! What a great explanation.
One of the Excellent video I have seen on UA-cam [ diff b/w Import and DQ ]
Nicely done, very informative. I look forward to the rest of the series.
Awesome, thank you!
Excellent job Manuel! Thanks
Great UA-cam. Manuel made it easy to follow material. I got a lot out of it. Thanks much!
Glad you enjoyed it!
Great and useful video! Muchas gracias, Manuel 🙂
Glad you enjoyed (:
Excellent overview! Thank you!
Where are the other related videos? (The 2nd video on Composite Mode)
Incredibly informative! Thank you
Glad it was helpful!
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 😉
Thank you for this Manuel
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
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.
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?
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.
@@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.
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.