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
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