cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Muki Helper I
Helper I

Re: Scheduled refresh failure: An item with the same key - Merged queries

Same here... (PBI Server Version 1.1.6582.41691 (October 2017))

 

I got 2 tables as a web source and I need to merge them into 1 table.

These tables have already different column names but I tried to rename them in the merged table to make sure they are unique in Power Bi Desktop.

Manual refresh works fine... but scheduled refresh on Server doesn't work...

 

 

Hope someone has a workaround for this situation too 🙂

Grtz

Muki

 

johncpratt Advocate I
Advocate I

Re: Scheduled refresh failure: An item with the same key - Merged queries

Hi all,

 

I can confirm the same issue on my end, with the added twist that I had a report working with a data refresh until I added a Merge Queries action.  I have resolved the situation using the stated workaround of making sure both queries involved in the merge action are sourced from a table rather than a SQL query.

 

In my specific case, I had a SQL view-based fact table with a column named "FiscalYear" imported using a SQL query that was filtering on a separate SQL view containing a limited number of fiscal years.  I also had a dimension table for the fiscal years using a table data source from the same view containing a limited number of fiscal years.

 

I then decided to limit the report to the current FY plus the prior 10, which required implementing the Merged Queries action on the fact table and a Keep First Rows action on the fiscal years dimension.  The data refreshed fine in PBIRS Desktop (October 2017), but the scheduled refresh under PBIRS failed.

 

For the workaround, I modified the data source for the fact table to pull directly from the view with no SQL query filtering in Power BI.  As soon as I did that, the Desktop refresh worked and running the scheduled refresh on the server also worked.

 

I hope this info helps identify the issue.  I am looking forward to the next release of PBIRS!

smelei
Frequent Visitor

Re: Scheduled refresh failure: An item with the same key - Merged queries

We've been experiencing this as well.

Raised as an issue, but haven't received any response as yet

Yousra Advocate I
Advocate I

Re: Scheduled refresh failure: An item with the same key - Merged queries

The issue seems to be fixed with the March 2018 update!

View solution in original post

Power BI Team
Power BI Team

Re: Scheduled refresh failure: An item with the same key - Merged queries

Thanks @Yousra for replying with the verification!

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.