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?
Add a comment
|
3 Answers
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.
3 Comments
GenDemo
This worked for me. But this is such a bad design on MS part.
Jem
Opening the advanced query editor did not give me any column parameter. However, when using Janzaib M Baloch's answer in combination with this answer, it worked. So I accessed the advanced editor through Janzaib's answer to see the columns parameter, but implemented the 'null' solution from this answer.
Susan Switzer
I appreciate your Columns=null suggestion. The columns argument somehow seemed to interpret not just the columns I am pulling in, but also any custom columns that I created.
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
4 Comments
Wouter
Is there no way to have it automatically done?
Jon
@Wouter - no you have to manually confirm the schema change
GenDemo
For me, it doesn't automatically update. This is such a bad design flaw!
euh
for me even that does not work tbh. have delete the model and add it again
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
Look for "Transform Sample File" on left hand side and select it
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.
