importing New data source

[Psk2606]

HI,

I have uploaded an excel file and created a report on Powerbi online.

Now I have added two more sheets to the excel file.

How do I make the report see these two worksheets as well as part of the data source.

If i upload the file to a new report, I can slect all three worksheets as my data files, but I already have existing data in teh report and do not want to ercreate the data in the report into a new report.

Is there anyways I can make powerbi online see the new worksheets?

[tharunkumarRTK · Accepted solution]

@Psk2606 

You can download the report that you have published to Power BI service and import the other sheets into your report and combine them. After combing all sheets to one you can disable the other two sheets to load into power bi . Then publish the report again. 

You can follow these steps: https://www.youtube.com/watch?v=sLW3NbeGDy8

If you have power bi premium/fabric capacity subscription then you dont need to download and publish the file. You can simply connect to the dataset that you have published previously using XMLA endpoint from tabular editor and make the changes to the M code and push the changes.

Need Power BI consultation, hire me on UpWork .

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun