Forum Discussion

jonasfernandes's avatar
jonasfernandes
New Member
1 year ago

[Fabric] Problems when refreshing dataflow if tables are hidden

Hello everyone!
I have a gen1 dataflow with Google Big Query tables.
The databases are medium-sized (~500k rows each) and I do some transformations (merges) with them. The dataflow works properly.

However, if I put some tables as hidden (disable load), the Dataflow starts to crash, giving the details below:
Param1 = DataSource.Error: ERROR [HY000] [Microsoft][BigQuery] (310) Storage API Error: Error: { code: UNKNOWN message: Stream removed } Request ID: 15d8c4a8-20fa-0157-ce5f-9e874e97066c.

I would like to hide some tables to improve user experience.
Does anyone know how to handle it?
Thanks so much!

Dataflow

1 Reply

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    1 year ago

    Hi jonasfernandes 

     

    As far as I understand, when you disable the load, that means the table will no refresh and is not actually hidden. I would recommend keeping the tables as is. And when you import the data into power BI desktop, you simply hide the table there.