Forum Discussion

rivo201's avatar
rivo201
Helper I
4 years ago
Solved

Dataset used as DirectQuery - column not appearing

Hi   Created dataset to use it as a DirectQuery connection to another workspaces/reports. All is working except: Later I've added a column to unerlying dataset, refreshed all reports in need, but t...
Need Help
  • rivo201's avatar
    rivo201
    4 years ago

    Yes. "Added column"  to PBIX (underlying data comes from API connection), published, confirmed that published dataset tables have requiered column. 

    Reports, that have been made before direct connected dataset has changed, do not have that added column.

    I looked into the PBIX (where dataset is referenced), if i refreshed (refresh all) data and event then column does not appear. 

    Column appears only, if i re-ceate/connect the dataset.

     

lbendlin's avatar
lbendlin
Super User
4 years ago

" Later I've added a column to underlying dataset"

 

Where and how?  In the PBIX file?  Did you then re-publish the pbix?

rivo201's avatar
rivo201
Helper I
4 years ago

Yes. "Added column"  to PBIX (underlying data comes from API connection), published, confirmed that published dataset tables have requiered column. 

Reports, that have been made before direct connected dataset has changed, do not have that added column.

I looked into the PBIX (where dataset is referenced), if i refreshed (refresh all) data and event then column does not appear. 

Column appears only, if i re-ceate/connect the dataset.