cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
luxhe
Microsoft
Microsoft

Information is needed in order to combine data

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?

9 REPLIES 9
abujohn
Frequent Visitor

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

v-deddai1-msft
Community Support
Community Support

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

 

v-deddai1-msft
Community Support
Community Support

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. 

Capture1.PNG

 

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.

luxhe_0-1611145614223.png

 

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?

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors