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.

     

rivo201's avatar
rivo201
Helper I
4 years ago

Hi, thank you for your answer. 

If I have DirectConnection to dataset, there is "no data to transform nor edit" - it is not visible in Power Query editor.

Main question still is: Do you really have to open file and reconnect all connection (lets say i have 100 reports using one common dataset) reports one by one.. it does not seem ideal..

lbendlin's avatar
lbendlin
Super User
4 years ago

yep, that's exactly what is happening in real life. It gets even worse when someone removes a column from the shared "golden"  dataset. The Power BI Service meta data engine is easily confused.