Integrate MS Lists in Power BI - not all columns shown

[paulschneller]

I have a list in MS Lists. I want to make a quick Power BI report with the "Integrate" function. I have done this before and it work flawlessly on other Lists.

However I ran into an problem with a new list. This one has a lot of columns. Here you can see a few of them:

If I use the integrate function I only get very few columns:

It is impossible to make useful graphs with that few columns. I have found no way to add columns myself. What am I missing here?

[collinq]

Hi @paulschneller ,

You may already know this but the best way to get MS Lists data is to use the SharePoint connector.  Specifically "Remember, you need only your SharePoint address. If you copy the /Lists component and/or the name of the open list, Power BI will return an error."  from this article: How to use Microsoft Lists with Power BI | TechRepublic

Here is a video on it as well:  https://www.youtube.com/watch?v=YOWxvT5XLoc&feature=youtu.be

[paulschneller · Accepted solution]

Thanks, I know. I can't use it in this instance, because I want to share it with the Team that uses the list and they need easy access to the report.

However I found a solution: The data in the quick report takes all the columns from the standard view of the list. I had to add the columns I need to the standard view and now it works as I need it.