Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
can anyone explain what are complex issues while developing powerbi dashboards at real time projects?
Hello Annapurna,
If I understand your question correctly, you're asking what you gain and/or lose with a live connection (a DirectQuery)? Is that correct?
Assuming that's correct, there are several links that provide much more detail than can be provided here but in general a DirectQuery is designed for large data sets and some of the standard functionality has been disabled to prevent your dashboard from having performance issues. This includes being limited to a single data source from a dashboard and caution regarding Row Level Security, which can have significant impacts. I'd recommend starting with the following link.docs.microsoft.com/en-us/power-bi/desktop-use-directquery#benefits-of-using-directquery. Hopefully I'm not too far off on what you were looking for.
Regards
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
104 | |
93 | |
64 | |
61 |