Forum Discussion
refreshing Import tables in a composite model
I'm trying to determine a dataset's refresh options (i.e., DirectQuery vs Import) when I have a report in mixed storage mode / composite model. My report is sourcing from an on-prem SQL Server in DirectQuery mode (to circumvent the 8x / day refresh limit) and an Excel file (which, of course, only supports Import mode). I noticed that when I publish the report to the service and inspect my refresh options on the dataset, the 'Scheduled refresh' menu is greyed out. So, it seems that having at least 1 table in DirectQuery mode in the report prevents any scheduling of the dataset. Is this true in general? If so, how can I refresh the tables that run in Import mode in the dataset? I read the link below, but it doesn't seem to give the answer.
https://docs.microsoft.com/en-us/power-bi/desktop-composite-models
Hi Anonymous ,
You need to add data source first. If you don't, you will get this:
If you want to use Personal Gateway instead of Enterprise Gateway, you need to Edit credentials first.
To configure scheduled refresh, you can refer to these documents:
Guidance for deploying a data gateway for Power BI
Manage your data source - Import/scheduled refresh
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi Anonymous ,
Have you add the two data sources to the same gateway before you tried to configure scheduled refresh?
Refresh a dataset created from an Excel workbook on a local drive
Refresh data from an on-premises SQL Server database
Manage your data source - Import/scheduled refresh
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
No, I have not created data sources under my gateway yet for this work. Is it expected that the lack of data sources under the gateway disables the 'Scheduled refresh' option?
Hi Anonymous ,
You need to add data source first. If you don't, you will get this:
If you want to use Personal Gateway instead of Enterprise Gateway, you need to Edit credentials first.
To configure scheduled refresh, you can refer to these documents:
Guidance for deploying a data gateway for Power BI
Manage your data source - Import/scheduled refresh
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
As per the document, If you have any many to many relationships in the datamodel.
Please try to avoid it with one to one, one to many, many to one.
Sometimes data model also causing the issue.
If the issue is still persists, please try to re-pro the issue with "Import Mode" and check for the setting in Power Bi Service.
Note:- Have you applied any Append or Merge?
If you have any concerns, please let us know.
If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?
