cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
khoahong Regular Visitor
Regular Visitor

PARTITION CONFIGURATION ERROR

Hi everone,

 

I imported data and made reports already. But now when I change the datasource of a table to odata, there is an error like this

Capture.PNG

I also tried another way by just importing the data, not replacing anything. But the error still incurred.

 

If I open a new report and import, it is ok.

 

I don't know what happened and how to solve it?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: PARTITION CONFIGURATION ERROR

Hi @khoahong,

 

Current, power bi incompatible with import mode and live mode(direct query, live connection).

 

In addition, if you want to apply some custom steps in query editor, please switch to import model.(direct query mode not support custom steps and queries anymore)

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

6 REPLIES 6
khoahong Regular Visitor
Regular Visitor

PARTITION CONFIGURATION ERROR

Hi all,

 

I imported a data and made report based on it. Now when I change the datasource of a table, there is an error like this:

"Failed to save modifications to the server. Error returned: 'Partitions that contain a full dataset (not sampled data) have to be configured for DirectQuery and Full Dataviews, or use Import query mode to retrieve data. This model apprears to have partitions that are non-compliant. Please check partition configuration.'."

 

I also tried another way by just importing the odata into the report, not replacing anything data. But the error still incurred.

 

If I open a new report and import the odata, it is ok.

 

I don't know what happened and how to solve it?

Community Support Team
Community Support Team

Re: PARTITION CONFIGURATION ERROR

Hi @khoahong,

 

Current, power bi incompatible with import mode and live mode(direct query, live connection).

 

In addition, if you want to apply some custom steps in query editor, please switch to import model.(direct query mode not support custom steps and queries anymore)

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

Highlighted
NickEtch Frequent Visitor
Frequent Visitor

Re: PARTITION CONFIGURATION ERROR

@khoahong

 

I came across this issue as well. It appears that if you deselect the "Enable Load" on the original queries that were brought in so that only the merged query remains, the merged query will then load without giving you the partition error. Everything is still in DirectQuery but only the merged table is available to use the visuals, filters, etc. in the report.

Sanny Frequent Visitor
Frequent Visitor

Re: PARTITION CONFIGURATION ERROR

hi NickEtch,

 

can you please send the snapshot for it 

" deselect the "Enable Load" on the original queries", i have no idea how to do this.

 

thanks

Sanny Frequent Visitor
Frequent Visitor

Re: PARTITION CONFIGURATION ERROR

it appears whether it is direct query or import mode, which depends the database structure. 

and it is not really depends on the user's selection. 

 

am i right?

 

Sanny Frequent Visitor
Frequent Visitor

Re: PARTITION CONFIGURATION ERROR

the method is not working, as when deselect "enable load", the data actually is removed  and error is still exists. 

 

 

 

 

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 43 members 861 guests
Please welcome our newest community members: