power bi导入文件夹
Power BI Desktop is a useful reporting and analytical tool to represent data in various formats. These presentations help us to quickly understand information and circulate it to stakeholders in a visual fashion.
Power BI Desktop是有用的报表和分析工具,可以表示各种格式的数据。 这些演示文稿帮助我们快速了解信息,并以视觉方式将其分发给利益相关者。
We can connect Power BI Desktop to disparate data sources including multiple relational and non-relation databases, Cloud, SharePoint, and Microsoft Exchange etc. In the real world, we use various file formats to represent our documents.
我们可以将Power BI Desktop连接到分散的数据源,包括多个关系和非关系数据库,云,SharePoint和Microsoft Exchange等。在现实世界中,我们使用各种文件格式来表示我们的文档。
In Power BI, we can get data from below file formats
在Power BI中,我们可以从以下文件格式获取数据
- Excel 电子表格
- Text\CSV 文字\ CSV
- XML XML格式
- JSON JSON格式
- SharePoint Folder SharePoint资料夹
Although popular as an export format, you cannot easily modify a PDF document, and it can contain the text, images, tables, and charts in PDF document.
尽管作为导出格式很流行,但是您不能轻松地修改PDF文档,它可以包含PDF文档中的文本,图像,表格和图表。
In Power BI Desktop, we cannot get data from PDF documents directly. Also, we do not have any option to use PDF as a data source. But suppose we want to extract a table from the PDF file and prepare visualizations on it. We can import data from PDF with following methods.
在Power BI Desktop中,我们无法直接从PDF文档获取数据。 此外,我们没有任何选择将PDF用作数据源。 但是,假设我们要从PDF文件中提取一个表格并对其进行可视化处理。 我们可以使用以下方法从PDF导入数据。
- Convert the PDF file to a Microsoft Word or HTML document and copy the table in an appropriate data source such as Microsoft Excel. It is a lengthy process and if we have to do the same process repeatedly, it quickly becomes cumbersome 将PDF文件转换为Microsoft Word或HTML文档,然后在适当的数据源(例如Microsoft Excel)中复制表格。 这是一个漫长的过程,如果我们必须重复执行相同的过程,则很快就会变得麻烦
- We can also use programming languages such as R to extract the required data from a PDF file. It requires extensive technical knowledge of a machine language such as R to work with these PDF files. If the format of the PDF files changes or we need to import a table from another PDF file, we require a change in the programming code. So this again creates organizational friction to contact developers and ask for the code 我们还可以使用R之类的编程语言从PDF文件中提取所需的数据。 要使用这些PDF文件,需要机器语言(例如R)的广泛技术知识。 如果PDF文件的格式发生更改,或者我们需要从另一个PDF文件导入表格,则需要更改编程代码。 因此,这再次造成组织上的摩擦,无法联系开发人员并要求提供代码
In both approaches, we require extra overhead to prepare PDF reports in Power BI. In this article, we will show how import data from a PDF file easily and without any coding.
在这两种方法中,我们都需要额外的开销才能在Power BI中准备PDF报告。 在本文中,我们将展示如何轻松地且无需任何编码即可从PDF文件导入数据。
Power BI PDF连接器 (Power BI PDF Connector)
The Power BI Desktop contains many preview features. These features are not enabled by default. We can use the PDF Connector preview feature in Power BI to use a PDF file as a data source.
Power BI Desktop包含许多预览功能。 这些功能默认情况下未启用。 我们可以使用Power BI中的PDF Connector预览功能将PDF文件用作数据源。
Launch the Power BI and go to the File menu. In the File menu, go to Options and settings and click on Options.
启动Power BI并转到“文件”菜单。 在文件菜单中,转到选项和设置 ,然后单击选项 。
It opens various Power BI configuration options. We can configure various options such as Data load, Power BI Query, R scripting, security, Report settings. We need to click on the Preview features menu option to use the PDF connector in Power BI Desktop data source.
它会打开各种Power BI配置选项。 我们可以配置各种选项,例如数据加载,Power BI查询,R脚本,安全性,报告设置。 我们需要单击“ 预览功能”菜单选项,才能在Power BI Desktop数据源中使用PDF连接器。