Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I am getting the following error in one of the reports that I have published into Power BI Service; I am getting this error whenever the dataset is refreshed, either as part of a schedule or manual, on demand refresh.
Cannot connect to the mashup data source. See error details for more information.
Underlying error message: | 2 arguments were passed to a function which expects 1. |
DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
Underlying error code: | -2147467259 |
Microsoft.Data.Mashup.ValueError.Reason: | Expression.Error |
Microsoft.Data.Mashup.ValueError.Arguments: | {Table.FromRecords({}), [...]} |
Cluster URI: | WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net |
Activity ID: | d890f718-4567-46a0-938f-bc1bb40cab2f |
Request ID: | febff131-1aec-464a-9c9f-960dde6e05ce |
Time: | 2017-03-07 05:01:17Z |
Oddly though, this dataset/report was being refreshed until 2 weeks ago, with the error started to appear since 24/2 morning. There hasn't been any changes to the report, so I am not sure what went wrong all of a sudden.
Thanks
Kaz
@Anonymous
Firstly, please update your gateway into latest version.
If it still throws same error, please download a .pbix copy, and go to Query Editor to check generated Power Query. As the error message indicated, try to pass only one argument in "Table.FromRecords" function.
Regards,
I downloaded a copy of the PBIX, and did a refresh. It refreshed all the data without any errors. I went and triggered a manual refresh in the Service, and expectedly, failed with the same error "
2 arguments were passed to a function which expects 1. |
I haven't upgraded my Data gateway, yet. Will be doing later today.
Thanks
Kaz
We are upgrading to the new data gateway tomorrow and I am hoping that it resolves our issues with data refresh. Nevertheless I am going to download the PBIX from the Clou dand see where is it having trouble. Interestingly though, the original PBIX refreshes without any errors on Desktop.
Thanks
Kaz
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.