Hi All,
we are from Power BI Guru e solutions we will do training's/resourcing /consultation and product development on Microsoft Technologies .
PowerBI Training in hyderabad ,
PowerBI Training in bangalore,
powerBi training in chennai,
powerBI training in Pune ,
PowerBI Training in Chennai,
PowerBI Training in Delhi,
PowerBI Training in Dubai,
PowerBI Training in Singapore ,
PowerBI Training in Abu Dhabi,
PowerBI Training in Ajman,
PowerBI Training in Dubai,
PowerBI Training in Fujairah,
PowerBI Training in Ras Al Khaimah,
PowerBI Training in Sharjah,
PowerBI Training in QATAR,
PowerBI Training in Oman
In this session i discussed about the import,direct query, live connection in Power Bi and the best practices to implement power Bi project enterprise level.
----------------------------------------------------------
Use DirectQuery in Power BI Desktop
-----------------------------------------------------------
With Power BI Desktop, when you connect to your data source, it is always possible to import a copy of the data into the Power BI Desktop. For some data sources, an alternative approach is available: connect directly to the data source using DirectQuery.
How to Connect using DirectQuery
When you use Get Data to connect to a data source supported by DirectQuery, the connection window lets you select how you want to connect.
The differences between selecting Import and DirectQuery are the following:
------------------
Import –
--------------------
The selected tables and columns are imported into Power BI Desktop. As you create or interact with a visualization, Power BI Desktop uses the imported data. You must refresh the data, which imports the full data set again, to see any changes that occurred to the underlying data since the initial import or the most recent refresh.
----------------------
DirectQuery
---------------------
– No data is imported or copied into Power BI Desktop. For relational sources, the selected tables and columns appear in the Fields list. For multi-dimensional sources like SAP Business Warehouse, the dimensions and measures of the selected cube appear in the Fields list. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, which means you’re always viewing current data.
Many data modeling and data transformations are available when using DirectQuery, though with some limitations. When creating or interacting with a visualization, the underlying source must be queried and the time necessary to refresh the visualization is dependent on the performance of the underlying data source. When the data necessary to service the request has recently been requested, Power BI Desktop uses recent data to reduce the time required to display the visualization. Selecting Refresh from the Home ribbon will ensure all visualizations are refreshed with current data.
for more details contact us at:
https://powerbiguru.com/contact-us/
call us : 0091-9704077815 call/whastapp
Thanks
Srinivas
Differences b/n import,DirectQuery, Live connection in Power Bi |Power Bi Training from PowerBI Guru camera iphone 8 plus apk | |
| 13 Likes | 13 Dislikes |
| 3,105 views views | 1.14K followers |
| Science & Technology | Upload TimePublished on 4 Apr 2018 |
Không có nhận xét nào:
Đăng nhận xét