Forum Discussion
Composite Data Model - unable to refresh with a calculated table?
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
Sapagrino - You can combine any number of datasets, add any custom/calculated tables you want. However, once you publish that composite model/dataset...in the Power BI Service go to the "Data source credentials" section and make sure all connections have a valid credential. In my case, it's a Microsoft account (we have a service account for Power BI). Hope that helps.
Thank you for the tip. I will look out for that. Maybe you have a helpful thought on the following? I have two major types of datasets (SetType1 and SetType2). Unfortunately, because of the massive size of SetType1's population, it is spread across 5 separate files (i.e., 5 pbi desktop files for different time periods, each published to its own PBI service dataset and report). I wish I could now simply append all 5 into one single table (since all columns are nearly the same) that I would then join to SetType2. I'm just wondering how best to think about appending things and joining things as I compile it. This isn't really my main skill set, but I'm learning how to do do a ton of things pretty quickly. Thanks for any thoughts you have.
Sapagrino - if you have 5 different datasets and bring them into a Direct Query model together and then try to UNION them, it's really the same thing as never having 5 different datasets to begin with and having 1 single dataset with all of them combined from the start. Your best bet would be to have a singular dataset, less work and less complexity that way. But if you absolutely must keep them separate, you go to the Power Query Editor and use Append Queries.