Refresh powerBI data with additional column

Question

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?

Answer 1

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:

   

2. In Power Query Editor, select Advanced Editor:

   

3. In Advanced Editor, increment the 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.

Answer 2

You can add the column in your new data source, when Power BI refreshes against the data set you will NOT see it in report designer. You will have to go into the Query editor, select the dataset & refresh the preview. It will then pick up the new column. It will now show in the report designer.

Hope that helps