Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
PPStar
Helper III
Helper III

Merging Dataflow data with SQL data in a semantic Model

Hi, 

I have a dataflow pulling in data from SharePoint (SharePoint List Updated)

 

I also have a Power BI Report which is pulling in data from a SQL Server. (Workspaces)

 

So the semantic Model is pulling in data directly into the semantic model and then i am using Dataflow to add additional data to the semantic model. 

 

I am trying to Merge some data from my dataflow with the data from the SQL Server. 

 

The SQL is pulling in the following data in the Workspaces: 

PPStar_0-1701880555256.png

 

My Dataflow is pulling in the following data via the dataflow in the SharePoint List Updated Table. 

PPStar_1-1701880597561.png

 

I have a 1:1 Relationship with the SQL table (Workspaces)  and my Dataflow table (SharePoint List Updated)

 

However, when i try to merge the two tables, as below -  together i get the following error 

PPStar_2-1701880972346.png

 

PPStar_3-1701880998792.png

 

 

Can anyone shed any light as to why i cannot merge the data?

 

Thanks 

3 REPLIES 3
aj1973
Community Champion
Community Champion

Hi @PPStar 

Create a Dataflow from SQL server then a 3rd Dataflow where you can link tables and merge them

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

edhans
Super User
Super User

I don't know why either as you are going through the UI, which should eliminate any typos.

Can you confirm that you don't have any trailing spaces in the name, and that the name doesn't have any high-ASCII characters? A fast way to do this is just rename it TEST, then do the merge.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Hi, 

 

NO trailing spaces. i redid the table in the dataflow with no spaces, all lower case. 

Still the same issue. 

To your point, im using the interface, which should eliminate any errors as such. 

 

im literally pulling my hair out. 

 

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors