Forum Discussion

pbi-ai's avatar
pbi-ai
Advocate I
3 years ago
Solved

Composite Data Model - unable to refresh with a calculated table?

I've created a report that connects to 3 existing Power BI Datasets via Direct Query. These 3 datasets have a date column as a common denominator

 

So I created a calculated table called Dates to join against these 3 datasets so that I can filter on a Date and it'll apply to all datasets:

Dates = CALENDAR(EDATE(EOMONTH(TODAY(), -1 ), -12) + 1, TODAY())
 
However, doing this...I'm unable to set up a refresh in the Power BI Service. Is this a known limitation?
 
 
When I delete the calculated table:

 

when I include the calculated Date table:

 

 
Note: I don't need a Gateway because all of my sources are in the cloud. In this case I have 3 datasets from Power BI and 1 calculated table that's just generating dates for the last 12 months based on today's date. It is an import table, but not imported from a data source...it's generated.
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , pbi-ai 

    Based on my previous testing and research experience, the reason why your "scheduled refresh" is not turned on should have nothing to do with your use of calculated tables, you can first try to check whether all the credentials configured for the data source under the "Datasource credential" section are valid:

    You can try to re-edit the credentials for each data source and check if "scheduled refresh" can be enabled.

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

8 Replies

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Community Support
    3 years ago

    Hi , pbi-ai 

    Based on my previous testing and research experience, the reason why your "scheduled refresh" is not turned on should have nothing to do with your use of calculated tables, you can first try to check whether all the credentials configured for the data source under the "Datasource credential" section are valid:

    You can try to re-edit the credentials for each data source and check if "scheduled refresh" can be enabled.

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

    • pbi-ai's avatar
      pbi-ai
      Advocate I
      3 years ago

      v-yueyunzh-msft - my data source credentials section has that exact same message as your screenshot. What credentials should I be using here? 

      Also, I forgot to mention...while I'm unable to set up a scheduled refresh...I am able to do an on-demand refresh without modifying any credentials. So for now if I need to use this composite model report, I just click the refresh button to do an on-demand refresh so I have the latest data. So is this really a credential issue?

       

      Also, note that if I remove the calculated table...it does show the option to refresh visuals on a schedule.

      • v-yueyunzh-msft's avatar
        v-yueyunzh-msft
        Community Support
        3 years ago

        Hi , pbi-ai 

        I did the test, I used a hybrid data model: Direct Query linked sqlserver, and created a calculated table:

        And after i configure the credential for my data source, i can configure the schedule refresh successfully.

         

        Best Regards,

        Aniya Zhang

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly