Interested to Buy Any Domain ? << Click Here >> for more details...
What are a portion of the distinctions in report creating capacities between utilizing a live or direct question association, for example, to an Analysis Services demonstrate, in respect to working with a data display nearby to the Power BI Desktop document?
- 1 Answers
- 16 Views
- I also Faced
- E-Mail Answers
Answer / Kumar Vivekanand Vivek
Some key differences between using a live or direct query connection and working with a local dataset in Power BI include:
1. Data freshness - Live connections automatically refresh data periodically, while local datasets require manual refreshes. Direct queries also allow for real-time data access without caching data locally.
2. Performance - Local datasets can sometimes provide better performance due to the ability to pre-aggregate and precompute data before loading into Power BI. However, live connections and direct queries can be more efficient with large datasets that don't require pre-aggregation.
3. Customizations - Working with local datasets allows for more flexibility in customizing visuals, formatting, and report layout as they are not dependent on the original data source.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the versions of power bi?
What are the features of power bi?
What is question collapsing in Power Query?
How to Implement Power BI Security?
What are the content packs in power bi?
What are the basics needed for using power bi?
How is the filter function used?
What are some ways that Excel experience can utilize with Power BI?
Is Power BI accessible on-premises?
What are the different types of filters in power bi reports?
Various excel bi add ins?
What is the need of signing up with work email?
QlikView 
