Refresh powerBI data with additional column
Feb 10
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?
azure1 answer
Accepted answer · original discussion
Jan 25
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.
In Power BI Desktop, right-click on your dataset under
Fields('VoterList' in this case), and selectEdit query:In Power Query Editor, select
Advanced Editor:In Advanced Editor, increment the
Columnsvalue:
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.
0 question comments
Use comments to ask for clarification. Post a solution as an answer.
No question comments on this page.