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".
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".