Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

PBI Dataset Direct Query Source missing column

Hope someone can help,   Connected existing report to a PBI Dataset on the service.   Have since updated this Dataset so that a particular table has an additional column.  Now how can I get this ...
Need Help
  • nickyvv's avatar
    nickyvv
    5 years ago

    Hi Anonymous,

     

    so what sources are you combining then? A Power BI dataset Live connection and what else?

    But, to my knowledge, for new columns to show up you'll have to refresh to model in Power BI Desktop and republish it to the service. They don't show up automagically unfortunately.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

If my understanding is correct, you originally connected to a Power BI Dataset as a data source in a live connection mode. After the data set was refreshed, a new column value should have been added but it did not appear. Is that right?

 

Best Regards,

Yuna

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous thanks for replying,

 

There was already a local model in the report so my understanding is that connecting to a PBI Dataset will add it to the local model with a Direct Query connection rather than Live?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ，

     

    Which connection mode does your local model use? Generally speaking, the following error warning will appear unless it is in live connection mode.

    Please refer to this link.

     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I am using the new feature mentioned here.  So in this case it is Mixed mode.

      • nickyvv's avatar
        nickyvv
        Icon for Most Valuable Professional rankMost Valuable Professional
        5 years ago

        Hi Anonymous,

         

        so what sources are you combining then? A Power BI dataset Live connection and what else?

        But, to my knowledge, for new columns to show up you'll have to refresh to model in Power BI Desktop and republish it to the service. They don't show up automagically unfortunately.