Table visualisation and URLs

[trevb]

Hi There,

My data has a URL to another site contained within it and I'd like to surface this in the data table and be able to follow it to the site (preferably in another window).  Does anyone know if this is possible or if it will be possible?

Also that site is a sharepoint site.  Is it possible to dynamically open that as a data source?  i.e. if each project has a link to a sharepoint site and has an "Actions" list can powerbi be set to list the data in each individual sites list in response to user interaction?

[Greg_Deckler · Accepted solution]

In the data model, Modeling tab, you can set a column to be a Web URL. It is the Data Category drop down in the last box on the ribbon. For your last request, I'm not quite clear but basically you would need to import those SharePoint lists into the data model and then you could have slicers or something that the user could interact with to display the data you want. Again, not quite clear on the requirement.

[trevb]

That's great, up and working straight away.

The second part of my query is esoteric really.  I want reporting of data within sharepoint sites associated with microsoft project.  These URLs point to those sites but it would be great to be able to read the list data from the sites in response to a choice.  I suspect this is not possible.

[Greg_Deckler]

No, you would have to import it and then display your information in something like a bar chart visual that would interact and filter the other visuals so that when you clicked on one of the bars, the other data would be displayed.