Advanced Single Table Refresh - Source value cannot be null

[henry_gonsalves]

I'm looking to refresh a single table in my Power BI datset on a more frequent basis than the rest of my model. How do I do this?

Data sources are Azure Databricks tables and a Sharepoint List. I want to refresh the SharePoint List table of my Power BI datsaset on a more frequent basis (or trigger this) independently toa scheduled refresh of the whole model.

This looks to be possible via the new preview features and advance refresh templates but following the documentation does not seem to work for me. Semantic model refresh activity in Data Factory for Microsoft Fabric - Microsoft Fabric | Microsoft ...

Setting up an advance refresh pipeline as pictured above always returns the error message: 

"

Error code

2015

Failure typeUser configuration issue

Details

Fabric activity failed. 'Value cannot be null. Parameter name: source '."

I cannot see where this Parameter is, it does not exist in my query and there is no box for this on the pipeline template.

Whilst I can select the workspace and semantic model I want to refresh the Table(s) option is always blank and doesn't return any tables in the model like I would expect. What is going wrong?

[v-sdhruv]

Hi @henry_gonsalves ,

I hope the explaination provided, has addressed your query.
Since we didnt hear back, we would be closing this thread.
If you need any assistance, feel free to reach out.

Thank you

[v-sdhruv]

Hi @henry_gonsalves ,

Just wanted to check if you got a chance to review the suggestion provided and whether that helped you resolve your query. If you have any questions you can reach out.

Thank You

[MFelix · Accepted solution]

Hi @henry_gonsalves ,

When setting up the refresh of the tables I also had problems connecting to see the tables in the semantic model, what I did was to make a new connection on the first step:

Then I selected a new one:

Then I was able to access the tables:

Retry to make the connection and then let me know, so I can also replicate the steps again.