Connect to sharepoint list with links

[Anonymous]

Hi All,
I have a sharepoint2010 list with links in them.

How should I load the data?
In this example, I have a list and the vehicle column is a link to other parts of SP.

If I load the list, I see all columns besides the links.

I can see the same list as a calendar as well, if I can load it as calendar, it also will be great.

Any ideas? Workarounds?

Thanks!

[v-yuezhe-msft]

@Anonymous ,

You define Hyperlink field in SharePoint, right? If so, to get this field in Power BI Desktop, you can expand the FieldValuesAsText column and use web URL data category. For more details, please check the following blog.

https://whitepages.unlimitedviz.com/2018/04/powerbi-report-hyperlink-picture-fields-sharepoint/

Regards,

Lydia

[Anonymous]

Hi @v-yuezhe-msft 

Thanks for the answer.

However my list does not contain hyper-links as ddescribed in the article above.

I have a column that have clickable values. These values open a new pop-up window with the object's details. This is an internal object in sharepoint.

For example, I have a list with vehicles rego numbers. clicking the value will open a new window with all vehicle details - Model, year, make, fuel type, etc.
When importing the list, I cannot see the column 'Vehicle' as all. I do see the other values.

[v-yuezhe-msft]

@Anonymous,

What do you mean that load it as calendar in Power BI Desktop? Do you want to show data as the above screenshot in Power BI Desktop? If so, you might need to create a visual organizing in Power BI.

Regards,
Lydia

[Anonymous]

By the way...

https://community.powerbi.com/t5/Desktop/Calendar-Charts/td-p/289716

Ta!

[Anonymous]

Hi,

That is a minor issue.

The question is how to get those links from shre point?!

Thanks!