February 6, 2019

Power BI Data Sources

Loaded Model: Offers fast response times, and includes scheduled reloads. If you can stay under 1GB (post compression) for Power BI Pro users, or the 10GB (post compression) limit for Premium users then the loaded model is the best choice. Direct Query: Directly querying the database is useful if you are analyzing large fact tables that are beyond the Loaded Model limit, or the data refreshes more than once an hour. Good network bandwidth is essential for Direct Query. Live Connect: Similar to Direct Query, but is used when querying data stored in Analysis Services, or HANA. It is highly recommended to leverage Analysis Services to manage row level security in Power BI. Mix Mode: Allows you have some of the tables in your PBI model to be loaded, and others to use direct query. This enables you to load smaller dimensional data in Power BI, and still use direct query for larger fact tables. Common Data Model: Using Dataflows within Power BI Service you can load
data from multiple systems and applications together. You can then create multiple PBI
Datasets from the model which can be leveraged in Power BI reports,
and dashboards.Power BI Data Sources

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

About McNeely DW BI

Ross McNeely is a Tail Wind Principal Consultant in Data Management, and the Practice Manager of Business Intelligence. He works with external vendors, customers, and partners to integrate disperse data sources. Throughout most of his 15-year career he has been specializing in Information Management, and implementing solutions for Information Strategy, Information Asset Management, Enterprise Data Management, and Business Intelligence.

Category

Azure, Power BI

Tags

, , , , , , , , , , ,