Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Auto refresh does not reflect the added column in dataset

Hi,

 

I have added a column in my table (source is sql database).

I have my corresponding report already published in power BI service.

 

After refreshing the datasets directly in service, the added column does not appear in the dataset.

Whereas, after refreshing the datasets manually in .pbix file, the added column is reflected in the dataset.

 

Please let me the reason of this behaviour.

Thanks in advance.

Need Help

3 Replies

  • zoloturu's avatar
    zoloturu
    Memorable Member
    8 years ago

    Hi Anonymous,

     

    It looks like a bug. The best solution is to raise a ticket to support via Power BI Service or Azure portal.

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

    Hi bidevsugmen,

     

    Are you using direct query mode? In direct query mode, when need refresh, power Bi will send an request package which contains a SQL query like(select XX from XX where XX) based on columns in your dataset in powr bi service. It doesn't check if the data model has been changed.

     

    However, you can see the added column after refresh your PBIX in PBI desktop because PBI desktop can check whether data model has been changed while PBI service can't.

     

    Regards,

    Jimmy Tao

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Jimmy,

       

      No, I'm not using direct query. 
      I'm importing the table as is.