Change query from one to another without losing the reports

[Anonymous]

Hello,

I'm new to Power BI and have recently built a set of reports. They are all based on one query/ table (Let's call this Table A) sourced from an Excel sheet (lets call this Excel A). Now, after a few months, I have reached end of limit for Excel A (max no. of rows reached).

Now I would like to add a New append query (lets call it Table Z) from Table B, C, D etc to be refreshed from Excel B, C/ D.. etc respectively as and when they become full.

Now, since my current reports are based on Table A, I would like to point them to the new Append Query (Table Z) without losing the reports. Could someone please guide me how to achieve this?

On the long term, I would like migrate the data to a database like MS SQL Server. But, that would be a different solution and would like that challenge parked for now.  My immediate need is to change the existing reports to pull data from Table Z instead of Table A.

Cheers

[v-eachen-msft]

Hi @Anonymous ,

Before appending tables, you could insert into a custom column each table in the query editor to show the time.

And this column can be used as a flag to show if it is the latest data.

[Anonymous]

Hi @v-eachen-msft ,

Thanks for your reply. Unfortunately, that is not required. When I followed any approach (Appending Table B into Table A or Creating a new Append Table Z containing rows of Table A and Table B), I could see all rows as required in table view.

But when the new records (I can indentify them because there is already a timestamp field in them), are not seen in the reports which were originally built on Table A.

Thanks,

Vivek

[judspud]

Hi @Anonymous 

You can append other tables into Table A.

This would mean you dont need to change anything in the report.

Hope this helps

Thanks,

George

[Anonymous]

Hi @judspud 

Thank you for your reply. I tried this already. Unfortunately, when I did this, though I could view the appended records (from Table B into Table A, when checking in Data view), the new records are not identified nor reflected in the reports.

Thanks,

Vivek