Power BI Refresh in Fabric pipeline

[girishtharwani2]

Hi,

I am using semantic model to refresh Power BI reports in fabric ADF pipeline. I have parameterized workspace and semantic model and will use it dynamically for all the reports. I want that all the tables inside the report should get refresh however when I dont give anything in Table, it is taking the values as null.

Is there a way we can refresh all tables inside the report ?

Thanks,

Girish

[v-mdharahman · Accepted solution]

Hi @girishtharwani2,

Thanks for reaching out to the Microsoft fabric community forum.

It looks like you are trying to refresh reports in the Power BI Dataset activity within the Fabric ADF pipeline. The Tables field allows you to specify which tables you want to refresh. When you leave this field empty, it defaults to NULL, which causes the activity to skip the table-specific refresh logic. Leaving it empty doesn’t trigger the refresh for all tables it will treat it as if no tables there so nothing gets refreshed.

Also there is type mismatches errors in Workspace ID and Semantic Model. Make sure these parameters are returning the required type.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

[girishtharwani2]

Is there a way we can refresh all tables inside the report without selecting table each and every time ?

[v-mdharahman · Accepted solution]

Hi @girishtharwani2,

Yes, you can refresh all tables inside the report without selecting each table manually. When you leave the "Tables" field empty or remove it completely, Power BI should trigger a full dataset refresh, which will refreshes all tables. you need to clear the "Tables" field completely, do not enter NULL or you can leave it as an empty string. If leaving it blank still results in NULL, try completely deleting the field. 

If ADF still treat the "Tables" parameter as mandatory, you can bypass it using the Power BI REST API. 

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

[v-mdharahman · Accepted solution]

Hi @girishtharwani2,

Thanks for reaching out to the Microsoft fabric community forum.

It looks like you are trying to refresh reports in the Power BI Dataset activity within the Fabric ADF pipeline. The Tables field allows you to specify which tables you want to refresh. When you leave this field empty, it defaults to NULL, which causes the activity to skip the table-specific refresh logic. Leaving it empty doesn’t trigger the refresh for all tables it will treat it as if no tables there so nothing gets refreshed.

Also there is type mismatches errors in Workspace ID and Semantic Model. Make sure these parameters are returning the required type.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.