'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?

azurepowerbiazure-data-lake-gen2


Solution 1:[1]

When you refresh you table and your data has new columns into it. Yes, it will give you issues. Or your new columns will just not show up.

Here is how you can fix it. Go to Transform Data and select transform data option step1

Look for "Transform Sample File" on left hand side and select it step2

Select advanced editor on top center and you should see something like this. and simply increase the number of columns your sample file can possibly contain. step3

Solution 2:[2]

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.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Janzaib M Baloch
Solution 2 Jeremy Caney

Related Questions