sharepoint online list

5 Topics

Attachments from sharepoint do not appear on public link
I have set an Power BI report with the data from a sharepoint list that has image attachments. When i use the public link i can see the images, but if i share that link with someone else they cannot see it. How do i fix this?
ToolsBI
3 years ago Place Report Server
1.6KViews
0likes
7Comments
Running the schedule updates to get data from SharePoint lists
Hello everyone, I'm trying to find the best solution to an unfortunate situation here: We created a big report with BI Desktop using SharePoint lists as data source, everything is working fine and looking good so far. Now we had to put it into production on our Report Server (because scheduled updates are exactly what we need) and for some strange reason it doesn't support the web version SharePoint lists (even though both products are from Microsoft)... How is this designed to be used in a situation like this? If I try to connect through the Report Server I can only authenticate as "Anonymous" or with "Windows Login", but as we are dealing with data that only a group of people in the company have access to we need to be able to log in using some credential such as an e-mail that has permission to view this information. Thanks.
Solved
Gilmar-Neto
4 years ago Place Report Server
1.5KViews
0likes
3Comments
Solution for Power BI reports using Sharepoint list as data source?
I'm working on a company that has several Power BI reports launched in the report server and they all have data refresh that works great because all the data sources are inside the local network (//company/files/etc). I'm building a brand new system that uses Sharepoint lists as the main database and powerapps as a way to manipulate this database by adding and removing items from those lists. So all data is in there. After ceating a new power bi desktop report using it as the data source, it all went fine. But then I figured out it does not work at all when uploaded to the report server. After reading a bit the documentation it is clear and it does not support auto refresh or whatever for sharepoint lists sources, so it won't work. I've been digging the internet to find the best solution but I just cant find any. I have thought of using the Power Automate flows to create a schedule to download all the lists in the sharepoint list to the local network and then use this as the datasource instead, but I'm stuck with this "on-premise gateway", no idea how it works. Does anyone know a way to work around it?
Solved
Anonymous
5 years ago Place Report Server
3.5KViews
0likes
2Comments
How to setup Sharepoint list datasource auto refresh on Power bi report server
i have couple of reports that pulling data from sharepoint list. how do i setup autorefresh on power bi report server. i have only two options in dropdown windows authentication and Anonmyous Itried windows authentication with office 365 user/pwd and also anonymaous both does not work. Do we have solution or work around (not using gateway my company don't support) to auto refresh sharepoint list on power bi report server. i am getting error: SharePoint: Request failed: Unable to connect to the remote server
Anonymous
6 years ago Place Report Server
1KViews
0likes
1Comment
Microsoft Account Authentication in PBIRS
On the newest Power BI Desktop for Report Server, I am able to connect to a Sharepoint Online list, using my Microsoft account. I deployed this to our Report Server and there is no way to use my Microsoft account to connect, so it will not be able to be automatically refreshed. How can I do this? I don't see any way to do it.
Solved
Anonymous
6 years ago Place Report Server
2.5KViews
0likes
3Comments