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

Thanks for replying Lydia. The queries themselves dont actually contain the credentials used to access salesforce though. I thought they are stored in the global permissions or the permissions for the pbix file.

 

Or are you saying there is a query for the overal pbix file. If so, do you think you could elaborate on where to find that?

 

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