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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Incremental Refresh with data from web source

Hey everyone,

 

I am trying to visualize time series data from web sources, like for example the euro exchange rates published by the ECB as an RSS Feed. The data is extracted from the xml file. However, the published data only contains the values of the past few days, as you can see in the picture.

z_teike_2-1662471771464.png

I implemented an incremental refresh, so past values (past 1 year) would be stored and only current values (past 1 week) would be refreshed. The incremental refresh has been set up as described here.

If I upload the report to Power BI Service and set up a scheduled refresh, the data will be refreshed, but past values will not be stored.

As a test, I tried to use a locally stored Excel sheet as data source instead and with this, it worked. 

 

Does anybody have an idea on why it doesn't work? Or is there any other solution to store the historical data?

 

Thank you in advance,

Zoe

 

P.S. I am using a Pro licence

2 REPLIES 2
Anonymous
Not applicable

Hi @v-zhangti,

 

thanks for your quick response. 

I configured the incremental refresh settings in Power BI Desktop, but still get the warning message, which says that the query might not be foldable:

z_teike_0-1662534711656.png

Since its not a SQL query I am not sure how to enable the "View Native Query" button (as explained in the link you sent).

z_teike_1-1662537671167.png

If you need any other information, let me know.

Thanks for your help and best regards,

Zoe

v-zhangti
Community Support
Community Support

Hi, @Anonymous 

 

Have you configure incremental refresh settings  on the power bi  service?

vzhangti_1-1662533272675.png

For reference:

Power BI Incremental Refresh for SQL Sources (mssqltips.com)

 

Best Regards,

Community Support Team _Charlotte

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors