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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
oneraj4u
Helper I
Helper I

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 static historical data table I append a current data table to.
I have to load the giant table using XMLA endpoints as it is too large to publish to Power BI Serviceand the regular refresh in Power BI Service times out. So I parameterize the table to use a dev data source which I can switch to prod once published, and also use incremental refresh to create partitions I can load using XMLA endpoints in SQL Server Management Studio (SSMS). I would like to disable the load of the tables used to create the append, but I cannot do so before publishing to Power BI Service as the tables are innaccessible via XMLA endpoints in SSMS as far as I can tell, and I can't load data to them.

oneraj4u_0-1695142246793.png

 

2 ACCEPTED SOLUTIONS
Greg_Deckler
Super User
Super User

@oneraj4u 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. 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

@oneraj4u 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?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

4 REPLIES 4
Greg_Deckler
Super User
Super User

@oneraj4u 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. 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

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?

@oneraj4u 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?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

October NL Carousel

Fabric Community Update - October 2024

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