Forum Discussion

roscas's avatar
roscas
Helper I
3 years ago

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 proble...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

 

 

 

roscas's avatar
roscas
Helper I
3 years ago

Anonymous 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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