Forum Discussion

PowerBINewbie_1's avatar
PowerBINewbie_1
Helper I
8 years ago

Different Data Sources within One Report with Multiple Tabs

  Hi Community Gurus!     How do you combine PowerBI reports that are compiled within different pbix files?   Currently I have two pbix files that I'd like to consolidate into 1. The breakdown ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi PowerBINewbie_1,

 

1. I would suggest you vote up this idea or create a new one for the feature merging files.

2. It seems possible if you can make sure the final statement of all the queries are the same. For example, one query "Table1" is from an Excel file, you can enter these data by hand and there will be a new query "Table2". Now, you can delete "Table1" and change the name of "Table2" to "Table1". 

 

 

Best Regards,

Dale

PowerBINewbie_1's avatar
PowerBINewbie_1
Helper I
8 years ago

Hi,

 

Thanks. I had to just use two different reports. I couldn't combine them :/

 

The first report was pulling from a data source. Lets call that A. Which had a whole set of data attached to the fields.

The second report was pulling from another data source. Also called A. But had different values attached because it is my test environment. Thus, when I tried to combine the fields I ran into errors because they are identical names with different values.

 

I did vote as you suggested.

 

Regards,

PBN 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi PowerBINewbie_1,

     

    What's the error message? Did you append these two queries?

     

     

    Best Regards,

    Dale