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
andrewtuplin
Advocate II
Advocate II

Incremental Refresh - Unable to see Table Partitions with a Pro License

Implimenting Incremental refresh on a PRO license is now possible, but veryifying that it works is not currently possible. 

 

With a Premium Licence, you can get the workspace endpoint and open it up in Analysis Services to see the tables and table partitions created, but this isn't possible with a Pro licences, so I'm not sure how develpers are intended to implement incremental refresh with PRO.  Without being able to see the table partitions created by the incremental refresh, we're flying completely blind. 

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi there

 

You are correct in that you cannot see the underlying partitions.


What I do is to upload the PBIX with say 1 months worth of data.

 

I then configure the Incremental refresh to be for the past 2 years.

Once the dataset has been refreshed for the first time I should then see all my data for the past 2 years.


This confirms that it is working as expected.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

2 REPLIES 2
GilbertQ
Super User
Super User

Hi there

 

You are correct in that you cannot see the underlying partitions.


What I do is to upload the PBIX with say 1 months worth of data.

 

I then configure the Incremental refresh to be for the past 2 years.

Once the dataset has been refreshed for the first time I should then see all my data for the past 2 years.


This confirms that it is working as expected.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Thanks. While I don't think that's as good as seeing the actual partitions, it at least confirms that incremental refresh is happening. 

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