Exchange Rates to load based on Dynamic Dates

[ncbshiva]

Hi Team,

I have created a function to load the Exchange rates currency based on the list of dates and to store them.

This works fine in the Power Query, but when i click apply and close i get an error message which is 

"Failed to save modifications to the server. Error returned: 'Expression in partition 'n/a' in table 'n/a' references an unknown entity. '."

I am attaching the PBIX file, can anyone please help me to solve this issue ?

Regards

SHIVA

https://www.dropbox.com/s/1350jr8zbgy45lm/Exchange%20Rates.pbix?dl=0 

[Anonymous]

Hi @ncbshiva ,

It seems the issue was caused by enable the preview feature "Store datasets using enhanced metadata format.", and it does not yet support dynamic datasources( the source changes depending on a parameter, function input, or volatile function). The related team is working on fixing the problem. The current workaround is disable this feature and re-create the report with new file...

You can review the contents in the following links for more details...

Using enhanced dataset metadata (preview)

Error on apply Power Query: Expression in partition n/a in table n/a references an unknown entity

Tibco TDV Connector: Error Expression in partition 'n/a' in table 'n/a' references unknown varia

Best Regards

Rena