Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We have a single SQL Server that has two databases on it.
Two schemas
dbo.
bi.
In dataflow power query I am wanting to merge two tables, one from each database together and then load into cds. I can load them, I can merge them, etc. but when I go to try to create it is saying there is an error with schemas.
I'm assuming that is because the tables are from two databases?
Is there a command or soemthing to merge these or convert the schemas.
Thanks,
Terry
When you say you can load and merge, I understand that (though that is extract and merge really), but what do you mean when you say "create?"
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCreate the table in CDS.
I'm not sure what that has to do with Power BI. You might need to check out a forum on putting SQL data in CDS.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.