Failed to save modifications to the server. Error returned: 'DirectQuery partition has '0' datasourc

Question

Hi,&nbsp;I'm trying to import different functions with no imput parameters from an on-premise SQL Server Database into PBI Desktop in Direct Query mode. It's all working good except for only one function that loads into Transform Data layer, so apparently it is working. But when it comes to load it into report (Close&amp;Apply), it generates the following error message just before to evaluate the data model relationships:&nbsp;"Failed to save modifications to the server. Error returned: 'DirectQuery partition 'fnBI001GetTestSampleGroupData-b67c5fb8-931d-4b80-a186-085dac875699' has '0' datasource reference(s) in its expression which is not allowed. '. "&nbsp;I already tried ti disable the "Store dataset using enhanced metadata format" and other options like "Automatic Relationship detection"I'm also been adviced that September 2020 release SHOULD fix this issue, but such release it is not available yet.&nbsp;Do you have any other ideas? Maybe faced the same problem and found a solution?&nbsp;Thanks,Francesco

fam · Answer

Greg_Deckler&nbsp;couldn't find anything helpful. Any other idea?Thanks

fam · Answer

Yes, if you notice I already asked a question&nbsp;😂&nbsp;but no useful answer yet.

v-easonf-msft · Answer

Hi ,&nbsp;fam&nbsp;
You can get the latest version(2.85.681.0 64-bit September 2020) of Power BI Desktop from the&nbsp;Download Center&nbsp;now.
Does the problem still exist in the new version？
&nbsp;
Best Regards,Community Support Team _ Eason

greg_deckler · Answer

fam&nbsp;You could check the Issues forum here:https://community.powerbi.com/t5/Issues/idb-p/Issues

v-easonf-msft · Answer

Hi,&nbsp;fam&nbsp;
Have you checked these related threads?https://community.powerbi.com/t5/Desktop/Failed-to-save-modifications-to-the-server-Error-returned-OLE-DB/m-p/1043148&nbsp;
&nbsp;
Try to download the latest version of powerbi desktop.
&nbsp;
Best Regards,Community Support Team _ Eason
&nbsp;
&nbsp;

Forum Discussion

Failed to save modifications to the server. Error returned: 'DirectQuery partition has '0' datasourc

7 Replies

Related content

DirectQuery FoldingWarning "UNSEARCHABLE" despite SQLColAttribute returning SQL_PRED_SEARCHABLE

DirectQuery Semantic Model

Fetch the File modification time

Failed to save modifications to the server. Error returned: - Solution required

Failed to save modifications to the server. Error returned: 'There's not enough memory to complete