且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在不暴露数据库元数据和数据密钥的情况下将BI数据传递到客户端

更新时间:2023-11-24 21:10:16

您好xxcmwxx,


***解决方案是站起来的PowerBI报表服务器,从数据库导出数据,并构建数据模型以支持客户需要的报表和仪表板。这会创建与数据库的隔离,并为您的客户提供他们想要的特定
数据。 


Power BI报表服务器


您还可以将历史数据导出到SQL数据仓库实例,以进行长期存储,然后使用Analysis Services构建模型并进一步增强数据,然后通过Power BI客户端向最终用户提供这些数据:  企业
带有SQL数据仓库的Azure中的BI


这是一个关于Power BI的好博客:  Power BI和Power BI指南架构图


我希望这些信息有用,


问候,


Mike


We have a request from a client to provide them with access to there raw data by granting read only access to our database.  In general, is this a good idea?  If it is not a good idea, what are alternative solutions?

Hi xxcmwxx,

The best solution is to stand-up a PowerBI Report Server, export data from your database, and build a data model to support reports and dashboards that your customer desires. This creates isolation from the database and provides your customer the specific data they desire. 

Power BI Report Server

You could also export historical data to an SQL Data Warehouse instance, for longer term storage, and then use Analysis Services to build models and further enhance the data, which then becomes available to the end-user through Power BI client: Enterprise BI in Azure with SQL Data Warehouse

This is a good blog with regard to Power BI: A Guide on Power BI and Power BI Architecture Diagram

I hope this information is helpful,

Regards,

Mike