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: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

MondialPowerBI

SQL Server Management Studio fails to process Power BI table partitions

Submitted by on ‎07-09-2021 06:08 PM

I've published a dataset containing three tables with incremental refresh on a premium-backed capacity. The normal refresh feature in the web portal does successfully refresh the most-recent partition for each, but SSMS isn't allowing me to forcibly process, and thus load up data for, any single partition or the entire table.

 

SSMS can connect to the model without issue via the endpoint, but attempting to "Process Table(s)" or "Process Partition(s)" only ever results in this exact error:

MondialPowerBI_0-1625878770479.png

This issue holds for every single mode selection in either window on both SSMS 18.6 (the oldest version that lets me successfully connect to the model) and 18.9.1 (the latest version). I have restarted my device and disconnected then reconnected everything from SSMS for both versions.

I am running Windows 10 Home version 21H1.

 

Status: New
See more ideas labeled with:
3 Comments (3 New)
Comments
v-chuncz-msft
Community Support
Community Support
‎07-12-2021 01:35 AM

@MondialPowerBI 

 

You may take a look at the link below.

https://feedback.azure.com/forums/908035-sql-server/suggestions/32896873--parameter-name-already-exi...

ferzfeld
Advocate II
Advocate II
‎02-13-2022 10:53 PM

I'm having the exact same problem here, and the link provided by @v-chuncz-msft is leading to a 404 😞 

ldittmann970
Advocate III
Advocate III
‎02-05-2024 08:50 AM

In case anyone else runs into this error - just want to call out I was able to resolve by following the guidance from this AAS Technet Forum: "parameter name already exists" while trying to Process Database in SSMS | Microsoft Learn
The issue was that I had identified a specific dataset in the Connection Properties of my SSMS 'Connect to Server' window.  Once I set the database to default (instead of a named dataset), I was able to process freely.

Idea Statuses