Couldn't load the data for this visual

[Anonymous]

Background - I have two data sources feeding into PBI: Associate information from SnowFlake, and Associate data from a SharePoint folder. I created new columns in the PBI data model using Lookupvalue to add the fields I wanted to include from SnowFlake to my Sharepoint data. Everything works and updates fine in the PBI Desktop but when I publish it I keep getting this error, can anyone provide a solution? 

[Anonymous]

Hi  @Anonymous ,

In general, this may be a privacy level issue. Please download the report and open it in Power BI desktop, go to Query Editor, refresh data to see if any message pops out. Also please go to the Data Source Settings, click on Edit Permission for these two data sources points to two databases, ensure both privacy level is Organizational. 

Then republish the report to Power BI service, go to Manage Gateways, ensure Privacy Level for these two SQL data sources is Organizational as well. Then refresh the dataset again. 

This is the related document, you can view this content:

Microsoft Idea (powerbi.com)

Solved: Processing error: Information is needed in order t... - Microsoft Power BI Community

Solved: Information is needed in order to combine data Tab... - Microsoft Power BI Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

It appears I've solved what was wrong. Due to filtering on my Snowflake source data there weren't matches for all of the data points I had within my Sharepoint data set, once I expanded my Snowflake data set everything refreshes as it should. 

[edhans]

Ahh.. so it was a data issue. Glad you found the issue @Anonymous 

[edhans]

You have an error in your data that when the full amount is evaluated, the column has errors.

I would NOT do this with LOOKUPVALUE. That is largely a workaround for those that just want a VLOOKUP equivalent in Power BI, but I never use it.

Instead, Merge the SharePoint and Snowflake data in Power Query on the key(s) you want, then expand the columns you want into the SharePoint data. If you aren't using the Snowflake data for anything else, you can mark the SF table to not load. Right-click it and uncheck "enable load." The data will still pass through tho the SP data.

Now, you may still get an error when loading if the data is bad. At this point you have two options:

1. Fix the source data
2. Filter out the errors with the Power Query feature to remove errors. On the Home Ribbon, Remove Rows, Rows with Errors.

Your data model will then load correctly, and the viz will work.

[Anonymous]

So I ended up at "LookUpValue" because I was getting an error when refreshing the published version of my PBI. The below error is what I'm getting - if I could get past that I would be all set. Any thoughts on it? FYI my Snowflake data is set up on a Gateway connection, but my SharePoint isn't 

Data source error:{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Information is needed in order to combine data"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"SharePoint\",\"path\":\"https://XXXXXsharepoint.com/sites/customerrm\"},{\"kind\":\"Snowflake\",\"path\":\"gdatapd1.east-us-2.privatelink.snowflakecomputing.com;WH_PD_PBI_Analytics_S\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySetting"}}],"exceptionCulprit":1}}} Table: Last login full data set.Cluster URI:WABI-US-EAST2-redirect.analysis.windows.netActivity ID:98a75b25-4c79-4e30-98d2-cda2769f6a20Request ID:23bf976f-1a4c-c10b-72c5-e79609582e14Time:2023-02-07 18:15:56Z