Forum Discussion
Couldn't load the data for this visual
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.
Community ChampionYou 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