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.
I meet an issue on refresh power bi report, and get the error:
Processing error: | Information is needed in order to combine data |
Cluster URI: | DF-MSIT-SCUS-redirect.analysis.windows.net |
Activity ID: | d22c15ce-5d4b-4ced-8880-d5259d98cd6a |
Request ID: | f9b51b45-abf7-75e4-8292-eb77747e3ebb |
Time: | 2021-01-14 09:58:20Z |
I followed the Solved: Information is needed in order to combine data Tab... - Microsoft Power BI Community But I still get the issue.
I used my own account, it could refresh successfully. But when I change to another account which is created by our team, not FTE account, the refresh is failed.
Could you give a help?
I am also getting this error : "Expression.Error: The field 'FileLeafRef.Suffix' of the record wasn't found" while refreshing the csv datasource which is hosted on sharepoint any fix for this issue
Hi @luxhe ,
It's better that you can show the m query for the sharepoint files query. And would you please refer to http://thebaretta.blogspot.com/2018/08/power-query-bi-data-refresh-error.html
Best Regards,
Dedmon Dai
Hi @luxhe ,
First check if the account have the same permission of your own account. And go to Manage Gateways, ensure Privacy Level for these all sources is public or none as well. Then refresh the dataset again.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi Dedmon,
I have already set all Privacy Level as None, including Data souce credentials in PowerBI web setting and PowerBI App.
And I didn't set Gateway connection.
I can refresh the data locally with the team account, but it failed when I refresh it in PowerBI web.
Hi @luxhe ,
What are your data sources? Would you please try to set download the pbix file and try refresh in Power BI desktop with all Privacy Level as None to see if the refresh in desktop works well?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi Dedmon,
The data source include
1. the sharepoint in the workspace.
2. Azure SQL DB.
3. Kusto table.
I already download the file and refresh in PowerBI desktop, it could load almost file except the sharepoint in the workspace. And I can use the user to access the sharepoint file in web.
Do you have any advice?
Hi @luxhe ,
What's the error message for sharepoint when you refresh the data in desktop?
Best Regards,
Dedmon Dai
The error shows as this.
The detail is:
Expression.Error: The field 'FileLeafRef.Suffix' of the record wasn't found.
Details:
ID=16
PermMask=0x1b03c431aef
FSObjType=0
HTML_x0020_File_x0020_Type=
UniqueId={2FCCDB0F-1F16-4AA9-B46F-FE7CBF12A773}
ProgId=
NoExecute=1
ContentTypeId=0x010100E405B9EDF72F6A4694B250B9535C9110
Even i am getting this error : "Expression.Error: The field 'FileLeafRef.Suffix' of the record wasn't found" while refreshing the excel datasource which is hosted on sharepoint from yesterday. Any known fix for this issue?
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.