Access Excel or CSV Files Saved on Power BI Report Server Directly
2) Open Power BI and select [Get Data], from main screen or “Home” menu on the Power BI desktop.
3) Choose [Web] as a query data source.
4) Enter the files URL, using the relevant API string: http://<your report server>/reports/api/v2.0/Resources( <your excel file's guid> )/Content/$value
5a. or b.) Once the query loads your source file, you should see a plain file icon, labelled with the same name as your report server. Notice that it loads the file as a binary file.
Right-click the icon (or click the [Open As] folder icon located on the left menu, just underneath the main Power BI commend bar). Both methods do the same thing, i.e. open a new menu bar with suggested “open as” file types. Select “Excel”, or whatever your file type is.
6 or 7) The next screen will load a table containing a list of any datasets held within your excel file.
In my example, I had data saved as an Excel table (labelled 6. on my screenshots). Power BI will also load any worksheets containing data, e.g 7 on my screen shots below. Click the dark yellow [Table] link
to open up your underlying excel data.
That’s it, wham, your excel file held on the Power BI Report Server should load.
Here is the M Script if you find it easier and can adjust the code to fit your file paths:
let Source = Excel.Workbook(Web.Contents("https://yourserver.0007.co.uk/PBIReports/api/v2.0/Resources(123abc456-your-files-GUID-here-789efg00)/Content/$value"), null, true), My_Sample_Data_Sheet = Source{[Item="My_Sample_Data",Kind="Sheet"]}[Data] in Source
相关文章
- LODOP导出excel的table合计值
- 如何用Python执行常见的Excel和SQL任务
- 前端读取Excel报表文件
- VBS将本地的Excel数据导入到SQL Server中
- Excel工作表忘记密码如何破解?
- java 使用jxl poi 操作excel
- Excel 2016公式与函数应用大全
- Excel 2016中文版完全自学手册
- [Excel/Word]常用函数与技巧
- excel打开csv格式的文件,数字末尾都变成零,解决方式
- vue在线表格(excel)
- POI导出Excel的三种 workbook的区别
- 解决Java POI 导出Excel时文件名中文乱码,兼容浏览器
- poi导出Excel(参照简单的例子)
- RDLC - 后台代码直接导出Excel/PDF/Word格式
- SautinSoft Excel 转 PDF .Net,查看详细信息
- 基于Java实现Json文件转换为Excel文件
- java 接口测试,使用excel做数据驱动(二)
- Interop Excel in PDMS
- dotnet OpenXML 读取 PPT 内嵌 ole 格式 Excel 表格的信息