Forum Discussion
Couldn't load the data for this visual
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?
5 Replies
- edhans
Community Champion
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:
- Fix the source data
- 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.
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
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:
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.
- edhans
Ahh.. so it was a data issue. Glad you found the issue Anonymous
