How can I refresh a table partition by month in power bi?

Question

I want to create a partition by month in master power bi report.When we will refresh the the power bi report it will show the data year wise.

Answer 1

Hello there,

Dataset table partitions aren't visible and can't be managed by using Power BI Desktop or the Power BI service. For datasets in a workspace assigned to a Premium capacity, partitions can be managed through the XMLA endpoint by using tools like SQL Server Management Studio (SSMS), the open-source Tabular Editor, scripted with Tabular Model Scripting Language (TMSL), and programmatically with the Tabular Object Model (TOM).

Advanced incremental refresh and real-time data with the XMLA endpoint https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla

Hope this resolves your Query !!

--If the reply is helpful, please Upvote and Accept it as an answer–

Answer 2

Double post