Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

edhans

Changing Direct Query models (composite) results in errors when applying changes

Submitted by Super User on ‎09-01-2020 10:09 AM

August 2020 desktop.

I had 3 tables loaded. 2 Direct Query to SQL Server, and 1 date table I created in Power Query using the min/max dates from one of the DQ tables using this method if it matters - Creating a Dynamic Date Table in Power Query

I loaded the model then decided I only needed two tables. So I went back into Power Query and:

  1. disabled  the "Enable Load" for the table I didn't need in the model - it was one of the SQL tables.
  2. For the table I did need, I merged the table in step 1 because I just needed a single field.
  3. Everything in Power Query looks good. So closing and applying should:
    1. remove the table in #1 above. There were no relationships to it in the model. It was standalone.
    2. Add the new column to the table I kept.

Instead I get this error:

edhans_0-1598979684469.png

 

By hitting "Discard changes" everything I did in Power Query was undone. Thankfully I had the presence of mind to:

  1. Create a new PBIX file.
  2. Copy all queries in Power Query from the old to new file
  3. Everything works fine in new file.

Full desktop model below, and I do have the enhanced metadata format turned on.

This is the second time in about a week this has happened. Always with Direct Query, though I've not tested this scenario with an Import model.

edhans_1-1598979779970.png

 

 

Status: New
See more ideas labeled with:
2 Comments (2 New)
Comments
v-yuta-msft
Community Support
Community Support
‎09-02-2020 02:46 AM

@edhans ,

 

I could not reproduce this issue currently, not sure the specific details in your "merge" step, if possible could you please share the two sample sql tables and the calendar formula so that I could make test on the august version and ealier version?

 

Regards,

Jimmy Tao

edhans
Super User
Super User
‎09-02-2020 02:29 PM

I would be happy to share the PBIX file with someone from MS, but it is to a local database. If you want the link, let me know and I can PM it to you. You may be able to open up the PBIX and see what is going on. You can clearly see what is in the data model, then when you go into Power Query, see it is quite different, even though the results of the queries would return errors for you not having the source database.

Idea Statuses