Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Merging PowerBI Table during SQL import query

Hi,   I have Table A in PowerBi as an import Query, I have Table B which is the result of a ODBC connection into our data warehouse using SQL. I want to a right outter join from Table A into Table ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

 

Best Regards,

Rico Zhou

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi,

     

    2.  Build a temp table A in SQL and merge it with table B in SQL then import the result table into Power BI.

     

    How do I build a temp SQL table using data from another data source (excel on shared drive) in powerbi?