Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Issue when changing sharepoint list column headers / reading description fields from columns in SPO

Hi guys, 


I looked everywhere but diddn't find an answer so here goes: 

for our "measure" glossary we use a sharepoint list (SPOL) (so every user has quick acces to is). 
We where planning on connecting each PBIreport to this SPOL so that we allso show this data on every first sheet of the report (as a reminder/catalog). 

So far so good, we stored this connecting in a PBI template to use for every new report. But when we adjust the SPOL (add new column or change a column name) this connection fails. 


Our question: 

1) can SPOL handle "labels" for column headers so that we only change the label of the column header, but the PBI connection to the SPOL doesn't brake

2) in the SPOL there is a "description" field per column. How can PBI read this "description" field ? (because the normal SPOL connector doesn't show it (I only found some info regarding Power APPS to use this "description" field) . 


Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!