Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
We have a report which data source is a combination of data comming from Azure Analysis Services and an excel file on a sharepoint site.
We activated the DirectQuery to AAS in preview options to get both data sources in a mixed storage mode.
However, when publishing to Power BI Service, the schedule refresh option is missing on the data set settings.
If all datasources were direct query this would totally make sense, however since we do have an excel file comming from a sharepoint site, the schedule refresh option is necessary.
Thanks for the help
I'm seeing the same issues with a direct query to Snowflake and import with HANA. We're using Incremental refresh with the HANA connection.
Snowflake is setup with a SSO connection and the HANA connection is through a gateway.
I am also facing similar issue where I have 3 different Datasource naming Shared DataSet (using a DirectQuery) , one excel file from Sharepoint Folder and last one Table from Oracle Database. I need to put the refresh on Schedule but the opion is not available.
Any Help here ! What could be the reason for this?
indeed that would be a normal spectation, but when using a composite model like this theres another behavior you need to take on account, some source as sharepoint/onedrive that are configured on the gateway to update, they do auto refresh on the composite model hourly, and around this behavior maybe its that the service isnt finding the need to give a refresh option on something that refresh automatically around the clock internally and a direct query mode that get data on request
hope this may give you some ideas or solve the problem and if it did, please let me know with some kudos 🙂
Proud to be a Super User!
There is no gateway configured, under gateway connection there is a message stating there is no necessary as all data sources are in cloud, however the report does not auto update the data from excel, for now we have to manually hit refresh on the workspace.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
52 | |
35 | |
32 | |
31 | |
25 |