Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
alicialcaide
Helper II
Helper II

Delete rows in Power BI Dataset using SSAS

‎11-03-2022 09:45 AM

Hi!

 

I have a Power BI published on a Premium Workspace. I'm using SQL Server and SSAS to access the tables and then, refresh partitions, for instance.

 

Now, I want to use SQL Server + SSAS to delete rows from specific tables that are already published in Power BI Service. Is it possible to do this with an MDX query?

 

Thank you.

Regards,

Alicia.

Labels:
Message 1 of 3
421 Views
0
2 REPLIES 2
GilbertQ
Super User
Super User

‎11-03-2022 03:18 PM

Hi @alicialcaide 

 

Unfortunately Power BI can only read in data it cannot delete data. This is by design

 

If you want to delete data you should look at using Power Apps to achieve this.





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

Proud to be a Super User!







Power BI Blog

Message 2 of 3
385 Views
alicialcaide
Helper II
Helper II
In response to GilbertQ

‎11-04-2022 08:36 AM

But with Power Apps (Power Automate, I think) can I connect to Power BI Server and then query the dataset?

Message 3 of 3
377 Views
0

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All