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

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    A bunch of other sources were already in the model (SQL, Excel, OData) before connecting to the PBI dataset. 

     

    Actually may not have tried a full refresh in desktop yet as didn't need all of the imported sources refreshed and it takes a while...so will give that a go tonight 🤞(have tried publising, refreshing on the service and downloading the .pbix without luck though)

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Well that did it!  Never occurred to me that refreshing all would affect the direct query connection.