Forum Discussion

warrencowan's avatar
warrencowan
Icon for Kudo Collector rankKudo Collector
9 years ago

Merge datasets into single report or use dataset as source

I'm querying Salesforce for a very specific email activity report, which only reports the details of the email activity of the user who is running the report at the time. It's daft, but nooone can ge...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi warrencowan,

You can copy entire table in Query Editor of each PBIX file with different credentials and paste the data of each table to Excel file, then connect to the Excel file from a new PBIX file.

Thanks,
Lydia Zhang

warrencowan's avatar
warrencowan
Icon for Kudo Collector rankKudo Collector
9 years ago

do you mean paste as in a static one time copy paste, or are you saying that excel can query the individual pbix files as data sources.

 

a one time export isnt going to help unfortunately as this a comstanty updating report.

 

if you mean the latter i must confess i am unfamiliar with excels ability to query powerbi

  • warrencowan's avatar
    warrencowan
    Icon for Kudo Collector rankKudo Collector
    9 years ago

    ok lydia scrub that last comment. ive just read up on excel querying powerbi. completely missed that release. i will try that out and report back.

    • warrencowan's avatar
      warrencowan
      Icon for Kudo Collector rankKudo Collector
      9 years ago

      Hi Lydia, I dont think this can work as when you change the sign in settings for salesforce in the pbix file, all the other pbix files inherit it. am I missing something

    • warrencowan's avatar
      warrencowan
      Icon for Kudo Collector rankKudo Collector
      9 years ago

      Hi Lydia, I dont think this can work as when you change the sign in settings for salesforce in the pbix file, all the other pbix files inherit it. am I missing something.

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi warrencowan,

        I mean that you copy entire table of each PBIX file, then press Ctrl+V to paste these data in Excel. After you merge data of these tables in a single  table in Excel, then connect to the Excel file in Power BI Desktop.


        Thanks,
        Lydia Zhang