Forum Discussion
Skilled SharerIssue importing HTML table into PBI: undesidered splitting tables
Hi
I am trying two import an HTML table into PBI. As result data are splitted into two tables: 14 colums in the first and 2 columns in the second table.
I can't use any join among them since I have different total rows.
Is there some parameters to correct the Surce step? I need to fix at this step before starting data modeling.
Sorry but I can't attach any file.
Regards
Thank you for your reply.
Really I was importing data from table with a new query
I apologize but I did not realize that columns in Table2 are really duplicate since the same column appear in the Table1.
Then I could delete Table2.
To be honest, I am not able to understand why PBI decided to behave in this way.
In any case issue solved right now.
Regards
3 Replies
- gpiero
Sorry,
I am trying to import........
- Fowmy
Super User
gpiero
Do you need to append or merge these tables?
Not clear about the exact requirement? Provide an example and fine output you require for a quick and better solutions________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
- gpiero
Thank you for your reply.
Really I was importing data from table with a new query
I apologize but I did not realize that columns in Table2 are really duplicate since the same column appear in the Table1.
Then I could delete Table2.
To be honest, I am not able to understand why PBI decided to behave in this way.
In any case issue solved right now.
Regards
