PowerBi可以动态加载文件吗?
我想我在这里进行了一次严重的一厢情愿的旅行,请确认我是否是,如果不是那么实现这一目标的过程是什么?
团队每天都会编译一个 Excel 文件并通过电子邮件附件发送。我有一个 Power Automate Flow,可将附件保存到 SharePoint 空间中。
我可以创建一个 Power Bi 并手动连接加载这些文件来创建报告,但似乎真正的“功能”是不必手动连接新文件(文件名中有创建日期 - 例如“每日 DRR”) 3-16-22.xlsx')每天,因此:
我需要采取哪些步骤(使用 Power Platform)才能使用 SharePoint 驱动器中的最后 5 个文件(天)自动(动态)刷新我的 PowerBi 报告?这可能吗?
提前致谢!
I think I'm on a severe wishful thinking trip here, please confirm if I am, if not then what would be the process to accomplish this?
Every day a team compiles an Excel file and sends it via email attachment. I have a Power Automate Flow that saves the attachment into a SharePoint space.
I can create a Power Bi and manually connect load those files to create the report, but it seems the real "Power" would be to not have to manually connect the new file (which has the creation date in the filename - eg 'Daily DRR 3-16-22.xlsx') every day, ergo:
What steps (using the Power Platform) would I take to have my PowerBi report auto (dynamically) refresh using the last 5 files (days) in the SharePoint drive? Is that possible?
Thanks in advance!
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论