Forum Discussion
Adding New Column not Reflected in Power BI Report
paulphe wrote:
I think I am missing something fundamental here.
When I first started with Power BI I used the Power BI desktop and linked to an EXCEL file on our corporate O365 sharepoint. I created the report I needed and published it to our corporate O365 Power BI Application. Once I had done this, anyone from our team could update information in the EXCEL file that would be reflected in the Power BI Report. So now that I want to add some columns of data to the EXCEL I need to access a query editor to achieve this (as you mentionned). However, in the Power BI report on O365, I do not have the Query Editor option.
So with the way this has been setup, how can I perform the changes I need while maintaining the relationships between the EXCEL on sharepoint and the established Power BI report?
Thanks in advance!
I don't exactly know how you "publish it to O365 Power BI Application"? If following Integrate Power BI reports in SharePoint Online, you just edit the pbix file and re-publish it to the same worksapce(click yes when a window saying "replace dataset" pops up). If not in this approach, per my knowledge on Power BI development, there shall be some replacing way that you can republish it to your "O365 Power BI Application".
By default, only previously loaded columns get loaded. This is to stop new rouge columns flowing into your report. Go into edit queries, go back to the first step and find the step that adds/removes columns. Click the cog and select the missing column
I think I am missing something fundamental here.
When I first started with Power BI I used the Power BI desktop and linked to an EXCEL file on our corporate O365 sharepoint. I created the report I needed and published it to our corporate O365 Power BI Application. Once I had done this, anyone from our team could update information in the EXCEL file that would be reflected in the Power BI Report. So now that I want to add some columns of data to the EXCEL I need to access a query editor to achieve this (as you mentionned). However, in the Power BI report on O365, I do not have the Query Editor option.
So with the way this has been setup, how can I perform the changes I need while maintaining the relationships between the EXCEL on sharepoint and the established Power BI report?
Thanks in advance!
paulphe wrote:
I think I am missing something fundamental here.
When I first started with Power BI I used the Power BI desktop and linked to an EXCEL file on our corporate O365 sharepoint. I created the report I needed and published it to our corporate O365 Power BI Application. Once I had done this, anyone from our team could update information in the EXCEL file that would be reflected in the Power BI Report. So now that I want to add some columns of data to the EXCEL I need to access a query editor to achieve this (as you mentionned). However, in the Power BI report on O365, I do not have the Query Editor option.
So with the way this has been setup, how can I perform the changes I need while maintaining the relationships between the EXCEL on sharepoint and the established Power BI report?
Thanks in advance!
I don't exactly know how you "publish it to O365 Power BI Application"? If following Integrate Power BI reports in SharePoint Online, you just edit the pbix file and re-publish it to the same worksapce(click yes when a window saying "replace dataset" pops up). If not in this approach, per my knowledge on Power BI development, there shall be some replacing way that you can republish it to your "O365 Power BI Application".