![]() Files stored in SharePoint on-premises can be loaded into Power BI, but only through Power BI Desktop. SharePoint – Team Sites allows files stored in any SharePoint Online library to be loaded. The personal workspace is the only type of workspace that allows a connection to personal OneDrive content. This is the type of OneDrive that is accessed using a “personal” account (otherwise known as a Microsoft account, or MSA). OneDrive – Personal connects to a user’s personal, or consumer OneDrive account. This is the OneDrive that is associated with “School or Organization” account which is stored in Azure Active Directory. OneDrive – Business connects to the currently logged in user’s OneDrive for Business storage. “Learn about importing files” is a simple help link, likewise available to all workspace types. This option is available for every workspace type and will not be discussed further. ![]() Files imported in this manner are not automatically refreshed, and without the use of a gateway, cannot be. “Local File” can be used for importing files from a local file store. It is not connected to any SharePoint sites, and provides 4 options for importing. The personal workspace is the only workspace available using the free Power BI license. The type of files that can be imported are CSV, Excel, PBIX (Power BI Desktop files) and RDL (paginated reports). In each example below, the options are reached by selecting “Get Data” and then choosing “Files”. There are 4 possible experiences, depending on the type and configuration of the workspace Let’s explore the 4 possible experiences when using “Get Data” and then choosing “Files” in the Power BI service. For the sake of clarity, a Modern SharePoint site is one that is backed by an Office 365 Group, and has an email address. However, any V2 workspace can be connected to any Modern SharePoint site, and in this way, the option is more flexible. V2 workspaces do not automatically offer this option, as there is no underpinning SharePoint site. V1 workspaces automatically offer the connection to the Documents library in the underlying SharePoint site. For example, these connections are automatically refreshed hourly unless that option is disabled. This post outlines the differences, and describes the configuration options.ĭata connections to files stored in SharePoint and OneDrive have certain unique characteristics when they are created in the browser. One area that this change affects a great deal is the “Get data” experience in the Power BI service (browser). ![]() The biggest difference between a V1 and V2 Power BI workspace is the fact that a V2 workspace is not backed by an Office 365 group, and a V1 workspace is. Power BI V2 workspaces recently (May 2019) entered into general availability.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |