Forum Discussion
XMLA Endpoint - Is it possible to disable / enable Table Load?
Anonymous While I may be wrong, I don't believe so. I believe that setting is actually metadata associated with a query, and the XMLA endpoint doesn't give you access to that.
Anonymous Not that I am aware of. The Power BI Rest API isn't going to do it. And editing the data model in the Service doesn't give you access to the queries either. Maybe something tricky with a dataflow? Probably not going to happen either. Perhaps it would be possible to cut your original history table down to just a year or two, publish to the Service and then activate incremental refresh on the table, something like that?
Thank you Greg
Are you aware of any way to disable load of a table once the report is in Power BI Service aside from XMLA endpoints?
Anonymous Not that I am aware of. The Power BI Rest API isn't going to do it. And editing the data model in the Service doesn't give you access to the queries either. Maybe something tricky with a dataflow? Probably not going to happen either. Perhaps it would be possible to cut your original history table down to just a year or two, publish to the Service and then activate incremental refresh on the table, something like that?
Thank you very much for your insights. 😊
End note for other users looking at this:
While I can do various methhods to load the data, and I do use dataflows with parametrized queries for the initial publishing - it appears that I will be unable to disable the load of a table in Power Query once published as of 9-19-2023