如何从每天更新的不同查询在 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屋！