Forum Discussion

henry_gonsalves's avatar
henry_gonsalves
Frequent Visitor
9 months ago
Solved

Advanced Single Table Refresh - Source value cannot be null

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 Learn

 

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?
Need Help
Tutorial Requests
  • MFelix's avatar
    MFelix
    9 months ago

    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.

     

3 Replies

  • MFelix's avatar
    MFelix
    Super User
    9 months ago

    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.

     

  • v-sdhruv's avatar
    v-sdhruv
    Community Support
    9 months ago

    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

  • v-sdhruv's avatar
    v-sdhruv
    Community Support
    9 months ago

    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