我使用SQL中的查询来生成报告，并且我有一个用于图像的var二进制列 .
使用GetData我把它拉进PowerBI，
我如何获得生成的图像？
我可以在PowerBI的查询编辑器中查看包含二进制代码的列
列名：图像
但是它在查询编辑器之外不可用
是否有一些设置我需要启用才能使其工作，或者甚至可能吗？
下面是我用来提取数据的查询：
Select
prd.ShortCode As 'Short Code'
, st.CountryName As 'Country'
, st.Concept As 'Partner'
, prd.StyleDescription As 'Product Description'
, prd.StockHoldingGroup As 'Stock Holding Group'
, dept.DepartmentNumber As 'Department'
, Sum(sls.SalesExVAT/sls.ExchangeRateEuro) As 'Sales Ex VAT'
, Sum(sls.SalesQuantity) As 'Sales Quantity'
, Count(Distinct(sls.BranchNo)) As 'No of Stores Sold'
, img.SmallImage As 'Image'
From
euuksql01.dashboard.dbo.Calendar cal
Inner Join
euuksql01.dashboard.dbo.Sale sls
On sls.DateID = cal.DateID
Inner Join
euuksql01.dashboard.dbo.Product prd
On prd.ProductID = sls.ProductID
Inner Join
euuksql01.dashboard.dbo.Department dept
On dept.DeptID = prd.DepartmentID
Inner Join
euuksql01.dashboard.dbo.DistrictStructure st
On sls.BranchNo = st.BranchNo
Inner Join
euuksql01.dashboard.dbo.ProductImage img
On img.ShortCode = prd.ShortCode
Where
cal.FiscalYearWeek = (Select FiscalYearWeek From euuksql01.dashboard.dbo.calendar where convert(date,getdate()-7) = FullDate)
And st.StoreType = 'Concession'
And prd.StockHoldingGroup Not In ('0441','0444','0445')
And dept.DepartmentNumber Not In (31,32,50,51,52,53,54,55)
Group By
prd.ShortCode
, st.CountryName
, st.Concept
, prd.StyleDescription
, prd.StockHoldingGroup
, dept.DepartmentNumber
, img.SmallImage
1 回答
不，Power BI不支持将二进制数据显示为图像 .
它目前仅支持显示image from URL / inserting image .
你可以找到相关的想法建议here . （由于
binary这个词，有很多垃圾评论...）