Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

SharePoint Columns Not Appearing in Power BI Dataset

I am a new user of Power BI but I can pretty much build simple dashboards. I created a SharePoint list which gets updated by a Power App I also built. In my SharePoint list, I have a column for the ...
Need Help
Show and Tell
Tutorial Requests
JoeBarry's avatar
JoeBarry
Solution Sage
2 years ago

Hi Anonymous 

 

When you load the list, there are many other columns that need to be expanded, the columns that are missing, I'm quite sure can be found within these. Just expand all columns until you find what you need, when you find it, delete the steps that you don't need.

 

Thanks

Joe

 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi JoeBarry, thanks for the response. I'm not sure I follow your steps. I don't have hidden columns to expand. The dataset has zero entries for  the employee ID, line of business, location, and supervisor name despite having entries in the Excel query.

  • christinepayton's avatar
    christinepayton
    Most Valuable Professional
    2 years ago

    Don't use the "export to Power BI" - instead open Power BI desktop and connect to the list with the SharePoint Online List connector. That will let you expand all the fields. If your list has under 5k items you can use the 2.0 connector, otherwise use the 1.0 connector. I did a video here on using SP list data in Power BI if that's useful - the fields expand a bit differently between 1.0 and 2.0, but the concept is similar: https://youtu.be/LYu3wqb2Nx4?si=_9kmJyBNuvw56Qon