Forum Discussion
Adding new column to PowerBI Dataset
Hi,
Currently, my PBI report is connected to a PBI Dataset and I'm looking to add new columns to this dataset from the source connection (in this case Alteryx).
WIll this cause any issues when I refresh the report? Will any of my visuals be affected or any of the measures that I've created?
Thanks
afk
6 Replies
hi, bo_afk
When you add a new column in Alteryx, if you want this column could be used in report, you need to update in "PBI Dataset" first. eg. download this pbix file and then update query code in Edit Queries like this post:https://community.powerbi.com/t5/Desktop/Date-cell-not-being-imported-from-CSV/m-p/582186#M275577
Then republish it to power bi service.
Now you could use this new column in the report, otherwise, it won't appear in next report.
Best Regards,
Lin
Thanks for your suggestion v-lili6-msft.
However, I'm unable the edit queries in my report as that option is greyed out. I can only select "data source settings". I assume this is because I'm connected to a Power BI dataset?
thanks
afk
hi, bo_afk
For example:
There is a datasource that you use it to create a report A, and then publish report A to Power bi service.
Now you use power bi desktop to connect to report A to create a report B.
Now, there is a new column in the data source. You need to download Report A file and then update query code in Edit Queries like this post:https://community.powerbi.com/t5/Desktop/Date-cell-not-being-imported-from-CSV/m-p/582186#M275577
Then republish it to power bi service.
Do not need to do these for report B.
Best regards,
Lin
