Forum Discussion
TextBox that shows text inputted from some online document
Hi there,
Happy to help! So Excel documents hosted on SharePoint have an ability to create "Surveys" which allow you to create a custom form (with link) that has a clean web interface, and then is loaded into an Excel table. Any data (text, numbers, etc...) can be inputs on this. More info on how to create it can be found here. You can then connect Power BI to that SharePoint Excel Table and grab any data you want from it, and throw it on a text visual on the report, filtered by bottom (most recent) input, date, etc... There's also a really great Long Text Viewer custom visual you can download for free from the Power BI Visuals Gallery, just search for that. Hopefully this helps point you in the right direction!
Reid Havens - Principal Consultant
Wow, thanks alot for the fast answer, buddy!
I have setup my survey now and that piece works perfectly well.
Which source type do I use to connect to this online excel ? In PBI Desktop I have Excel which is a file, I got sharepoint online and sharepoint list. But not Sharepoint Excel..
Any idea which "Get Data" connector to use? Thanks!
Absolutely! So web web would be the one you want, though you can also use SharePoint online. There's a great set of replies to how to connect on a PBI Community Post here.
