Exchange Rates to load based on Dynamic Dates

Question

Hi Team,&nbsp;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&nbsp;"Failed to save modifications to the server. Error returned: 'Expression in partition 'n/a' in table 'n/a' references an unknown entity. '."&nbsp;I am attaching the PBIX file, can anyone please help me to solve this issue ?&nbsp;RegardsSHIVA&nbsp;https://www.dropbox.com/s/1350jr8zbgy45lm/Exchange%20Rates.pbix?dl=0&nbsp;

anonymous · Answer

Hi&nbsp;ncbshiva&nbsp;,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(&nbsp;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 entityTibco TDV Connector: Error Expression in partition 'n/a' in table 'n/a' references unknown variaBest RegardsRena

Forum Discussion

Exchange Rates to load based on Dynamic Dates

1 Reply

Related content

Exchange Rates - Historical

Live currency exchange rate

Using exchange rates

Historical exchange rate API

Utilization Rate