azurepowerbiazure-data-lake-gen2

Refresh powerBI data with additional column

I have built a powerBI dashboard with data source from Datalake Gen2. I am trying to add new column into my original data source. How to refresh from PowerBI side without much issues or whats the best way to do?

Solution

  • You can configure the query so that the number of columns is dynamic by setting Columns=null.

    These instructions get you to the same place as @Janzaib's answer, but are more intuitive for me.

    1. In Power BI Desktop, right-click on your dataset under Fields ('VoterList' in this case), and select Edit query:

      data set context menu

    2. In Power Query Editor, select Advanced Editor:

      Power Query Editor

    3. In Advanced Editor, increment the Columns value:

      Advanced Editor showing Columns value

    Note: If you increment this value larger than your data set, you will end up with empty columns.

    However, if you set Columns=null, then it will import all of the columns found in your source automatically, even as your source changes.