SharePoint all columns not showing in Bi

[KKShan]

Dear Friends ,

Need your insights. I am connecting Sharepoint to Power Bi report server. On my Bi , query editor only few columns are visible. Other columns are not showing in query editior. Even i haven't removed any columns via applied steps. Any idea?

Your inputs will be highly appricitaed. 

[DivyaBalu]

In my case, issue was with the default view. if you have multiple views created in the list, make sure that the fields required for the BI report is also added for the default view. It works 100%.

[KKShan]

Hi Yingyinar ,

The link you have shared helped with my solve my Sp connecting issues in Bi. Thanks a lot.

Regards ,

KKShan

[v-yiruan-msft · Accepted solution]

Hi @KKShan ,

Which type of SharePoint data source you are connecting to? SharePoint Online List or something else? Could you please provide the related screenshots which the fields display in SharePoint and Power BI Report Server in order to know which fields are missing? By the way, how did you connect to SharePoint? Thank you.  

You can refer the content in the below blog to connect to SharePoint...

View Reports on Real-Time SharePoint Data in Power BI Report Server

Best Regards