Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
roscas
Helper I
Helper I

Empty Table

Hello, I need your help to fix this issue.

How can I correct this error in Power Query,

one of the steps is to apply a filter, normally after refreshing the report the table is updated.

The problem I have now is that after applying the filter, the table is empty, and the query is not updated. "Download did not complete" error. Is there any way to bypass this error and load the table showing zero values (0)?

 

Thanks

 

1.png

2.png

5 REPLIES 5
Daryl-Lynch-Bzy
Resident Rockstar
Resident Rockstar

Hi @roscas - ah, I see that you have Pivot Column step.  This step will require rows with data other no columns are returned - no columns no table, so now you error message makes sense.

 

DarylLynchBzy_0-1673630055750.png

As a work around, you need to include and extra to checks if the table is empty and if so create an empty table as a substitute.  Something like this:

= if Table.IsEmpty( #"Pivoted Column" ) then #table( type table[Column1=text, Column2=text] , {} ) else #"Pivoted Column"

 

 

Daryl-Lynch-Bzy
Resident Rockstar
Resident Rockstar

Hi @roscas - I am not sure how to help because Excel and a Power BI Dataset/Dataflows will load empty tables. 

 

DarylLynchBzy_0-1673628536056.png

 

DarylLynchBzy_1-1673628593876.png

 

@Daryl-Lynch-Bzy thanks for your recommendation, the problem I'm having is that if I apply this, a new table will be created. I need it to show zero in the same table, since this table is referenced with other formulas.

Hi @roscas - it is possible to include a row with Blank in this table.  Please refer to the Gorilla Bi Creating Tables - see the example in the #table constructor.

= #table(
     type table[ ProductKey = Int64.Type, Product = Text.Type ],
     {
        { 1, "Apple" },
        { 2, "Prume" }
     } 
) // Creates a table with specified Data Types and Column Names

   

Hi Daryl

The excel file is not empty, if you see the steps before apply Filter there are 128 rows, after filter is empty

3.jpg

 

 

 

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors