Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Automatically update usage statistics across multiple reports

Hello everyone!   I have two premium workspaces (A&B) with two different reports in each one of them. I have the usage statistics (auto generated by PowerBI) for each of the different reports sepa...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you for this!

 

Few things I noticed, it seems like I can't do any manipulation within Power Query as in appending datasets/pivoting/unpivoting

 

Secondly, it will only let me add PowerBI from one source only, i.e. once a a PowerBI dataset is in, I can't bring in anything else. Not sure why its doing that

_sfrost's avatar
_sfrost
Solution Specialist
5 years ago

Anonymous 

Did you enable the preview feature 'Direct Query for dataset' in desktop settings? That could be the reason why you are not able to add another dataset. I just tried and I was able to add multiple dataset connections in DQ mode.

And regarding appending tables, may be you can make use of Union() DAX function.

 

If not, seems it's possible to acheive this requirement with paginated report as explained in the below article.

(1) Automate Power BI Usage data across workspaces using Paginated Reports | LinkedIn