Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
DMPBR
Frequent Visitor

Cache refresh without using scheduled refresh

Hi All,

 

I am unsure if it is possible to do what I want to do however thought I would ask before re-engineering a large(ish) report. 

 

We pull data directly from D365 Online and surface this through various filtered tables and visuals to provide our leadership with data. Unfortunately, D365 online isn't supported for scheduled refresh therefore we are currently opening the report every day, refreshing the data and then saving it again.

 

Anyone know if there is a way to refresh this cached data automatically from D365? My workaround failing this will be a scheduled data extract from D365 to SQL and then a scheduled refresh into PBI, however this is less than ideal as the D365 export isn't great 😞

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User


@DMPBR wrote:

Anyone know if there is a way to refresh this cached data automatically from D365? My workaround failing this will be a scheduled data extract from D365 to SQL and then a scheduled refresh into PBI, however this is less than ideal as the D365 export isn't great 😞


The issue is that the on-prem PBI Report Server does not support the ability to authenticate to cloud based data sources. So your workaround of using an intermediate data store like a SQL Server is the only way to make this sort of scheduled refresh work.

View solution in original post

2 REPLIES 2
d_gosbell
Super User
Super User


@DMPBR wrote:

Anyone know if there is a way to refresh this cached data automatically from D365? My workaround failing this will be a scheduled data extract from D365 to SQL and then a scheduled refresh into PBI, however this is less than ideal as the D365 export isn't great 😞


The issue is that the on-prem PBI Report Server does not support the ability to authenticate to cloud based data sources. So your workaround of using an intermediate data store like a SQL Server is the only way to make this sort of scheduled refresh work.

Thanks, I thought it was likely the case but no harm in asking 🙂 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.