Appending Datasets Error

[qandersonderm]

For some reason a dataset errors out when refreshing in Power BI Service.  The error specifically happens when appending two datasets together.  Dataset A comes from power bi dataflows, dataset B comes from an EDW Synapse Server.  Both datasets are able to be refreshed when pulled in independently without merging them.  The other twist on this is that other people in my organization at a same access level in the Power BI Service workspace are able to refresh the dataset when they take ownership of the data.

I have checked and we have identical access credentials in the EDW and both are assigned as admin roles in the power bi workspace.  I've also checked the credentials of the datasets in power bi desktop and they are both set to public security levels in the desktop application.  When I refresh the dashboard on my local machine the refresh does not cause any errors.

The error power BI service is outputting is posted below.

Data source error: Information is needed in order to combine data;Information about a data source is required.. The exception was raised by the IDbCommand interface. Table: In-TransitInventorySnapshot (2).
Cluster URI: WABI-US-WEST2-redirect.analysis.windows.net
Activity ID: 01f4d258-a683-457e-8a62-d95d87e0546e
Request ID: a8b899a3-197e-283a-615a-cfe025767846
Time: 2023-07-11 17:54:34Z

[qandersonderm]

The issue has been solved.  Thank you.

[qandersonderm]

I am running a union between two datasets.  This is the the full code that creates the error.

let
Source = #"In-TransitInventorySnapshot",
#"Appended Query" = Table.Combine({Source, #"vw2_integrichain ChannelDailyInv852Snapshot_DOH_PU"})
in
#"Appended Query"

Both datasets In-TransitInventorySnapshot and vw2_integrichain ChannelDailyInv852Snapshot_DOH_PU have been imported separately.  When updating the dashboard on power bi server without the dataset built off the above query the dashboard refreshes without issue.  When it is present the refresh fails.  When another person in my organization with the same power bi and synapse credentials takes over the dashboard the dashboard also refreshes without issue.

I am trying to understand what could cause my account to have an issue refreshing the dataset while an account with equivalanet access to both power bi server and synapse does not have the issue.  Does that clarify the issue?

[lbendlin]

Those are not datasets.  They are data sources. Data source credentials can differ between Power BI Desktop and Service. You can add complexity by authenticating via OAUTH2  (for example) which would then dynamically apply the permission scope of the user attempting the refresh of the dataset containing these data sources.  

another person in my organization with the same power bi and synapse credentials 

you may find that that is not the case. Likely they have different permission scope.

Note that you can neither update nor refresh dashboards.  PLease take the time to use the correct terminology.

[lbendlin]

when appending two datasets together.  

That's not a thing. You probably mean "data sources"?

"append" and "merge" have different meaning too.

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?