Adding new column to PowerBI Dataset

[bo_afk]

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

[v-lili6-msft]

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

[bo_afk]

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

[v-lili6-msft]

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

[bo_afk]

Hi @v-lili6-msft ,

Thanks for the explanation. However, I still can't seem to update the query code in Edit Queries as it's still greyed out. I should also mention that I initially created report A in Power BI Desktop so I assume there is no need for me to download the report from Power BI Service? I did try to download it from Power BI Service but again, was unable to edit queries.

Sorry if I'm misunderstanding this.

[v-lili6-msft]

hi, @bo_afk 

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Best Regards,

Lin

[v-lili6-msft]

hi, @bo_afk 

Do you mean that "report A" is also connected to a power bi service dataset? If so you need to find the first report that is connected to data source, not connect to power bi dataset. then download it from Power BI Service and edit queries,

then republish it. this report is not originally connected to the data source.

Best Regards,

Lin