英文:
Sending values from SharePoint list to Power BI Desktop
问题
如何将SharePoint列表中的数值发送到Power BI Desktop作为参数或其他方式？我已经尝试了一些方法，如在链接中嵌入数值，但它不起作用，有人可以解释一下我该如何做吗？
英文:
How can I sent values from a Share Point list to Power BI Desktop as a Parameters or whatever ,I've tried few ways like embedding values in links but it is not working , can someone explain it to me how can i do this ?
答案1
得分: 2
你不能这样做。你可以添加一些条件来从SharePoint中获取数据，但这些条件将是静态的，例如Id=1将是条件，但你不能直接将这个条件动态地添加到SharePoint中。你首先需要将数据加载到Power BI数据集中，这样你就会拥有所有ID的记录，然后你可以在Power BI中添加筛选器/切片器。
英文:
No you cannot do that. You can add some criteria to fetch data from sharepoint but that criteria will be static, for ex Id=1 shall be the criteria but you cannot directly add this criteria to sharepont and that too dynamic. You first need to load data into powerbi dataset so you will have records with all IDS and then you can add filters/slicers in powerbi
答案2
得分: 0
在Power BI中，参数更像全局变量，而不像您在其他工具中习惯的方式。它们是外部化引用的绝佳方式。
如果您在Power Query中为特定记录子集设置了筛选器，这个筛选器将被折叠（在数据源上运行），而不是事后。在执行PQ命令时，执行顺序很重要，以实现折叠。
我在与我的博客文章关联的视频中展示了这种筛选方式：https://marqueeinsights.com/how-to-data-mine-a-sharepoint-list-with-power-bi/ 我正在撰写一系列的帖子，这些帖子是关于SharePoint/PBI特定的，因为它们之间的互动文档不足。
另外，您的需求是否基于用户？如果是的话，请查看RLS。这可以让您根据查看用户的配置文件自动进行动态筛选。
希望这对您有所帮助！
Treb Gatte
Microsoft Power BI MVP
英文:
Parameters in Power BI work more like global variables rather than what you are used to in other tools. They are an excellent way to externalize references.
If you set a filter in Power Query for a specific subset of records, this filter will be folded (run at the datasource) rather than after the fact. Order is important when executing PQ commands for folding to occur.
I show this filtering in the video associated to my blog post here: https://marqueeinsights.com/how-to-data-mine-a-sharepoint-list-with-power-bi/ I’m doing a series of posts that are SharePoint/PBI specific since the interaction between them is poorly documented.
Also, is your need user based? If so, take a look at RLS. This enables you to do dynamic filtering automatically, based on the viewing user’s profile.
Hope this helps!
Treb Gatte
Microsoft Power BI MVP
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论