如何通过每天更新的不同查询在Power BI中创建新的数据表? [英] How can I create a new table of data in Power BI from a different query that updates daily?

问题描述

我有一个SQL执行函数，可以在Power BI上生成一个简单的表.当用最新数据刷新时，此表更新，这很好.我想知道是否有一种方法可以在Power BI中创建一个新表，该表是SQL查询中的历史数据?这个想法是原始查询每天在指定的时间更新，然后将数据复制并附加到带有时间戳的第二个表中，因此随着时间的流逝，我将拥有原始执行的SQL函数的历史数据.这有可能吗?有没有办法使其自动化，所以我不必每天手动添加数据?

I have a SQL execute function generating a simple table on Power BI. This table updates when there is a refresh with the latest data, which is good. I was wondering if there was a way to create a new table in power BI that is the historical data from the SQL query? The idea would be the original query updates at a set time everyday, and then that data gets copied and appended to a second table with a timestamp so over time I will have historical data of the original executed SQL function. Is this possible, and is there a way to automate it so I don't have to manually append data every day?

推荐答案

Power BI并不是要用作存储历史数据的数据库.在Power BI中可能存在一些 不稳定和/或丑陋的解决方法，但是最好使用适当的工具来完成工作.将历史数据保存在数据库中，然后将Power BI连接到数据库.

Power BI is not intended to be a database for you to store historical data. There might be some unstable and/or ugly workarounds to do what you're suggesting in Power BI but it's much better to use the proper tool for the job. Save your historical data in the database and connect Power BI to that.

这篇关于如何通过每天更新的不同查询在Power BI中创建新的数据表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！