Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

XMLA Endpoint - Is it possible to disable / enable Table Load?

Is there a way to disable a table from loading using XMLA endpoints ( either in SQL Server Management Studio Analysis Services or Tabular Editor 2.0) ? Background: My issue is I have a giant stat...
Need Help
Tips and Tricks
Tutorial Requests
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

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?

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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