2 workspace auto-produce 2 usage report datasets - PB doesn't allow to upload BOTH sets in 1 report

[Anonymous]

2 workspaces produce 2 usage metrics report datasets - but Power Bi doesn't allow to upload both datasets in 1 Power Bi desktop report ?

I have 2 workspaces (A, B) and I confirmed that each workspace produce a different dataset for (A, B).

I opened Power Bi desktop with the aim of creating my own report to display usage data for each workspace in 2 report tabs for A, B However, to my surprise, the desktop report only alllows me to use 1 dataset, you can't upload both datasets in the same desktop report. Once you upload 1 of the datasets (A or B), the GET DATA menu will gray out.

DOES ANYONE KNOW WHY THIS HAPPENS....AND HOW TO SOLVE THIS PROBLEM, SO I CAN UPLOAD BOTH DATASETS INTO 1 POWER BI DESKTOP REPORT ???

[v-yalanwu-msft]

Hi， @Anonymous ；

Did you mean conneting to power bi dataset in power bi desktop? We can look at its limitations：
1.That is a live connection, left-navigation and modeling are disabled. You can only connect to one dataset in each report. This behavior is similar to the behavior when connected to SQL Server Analysis Services. However, the following article describes how a new feature in Power BI now makes this possible: see using DirectQuery for Power BI datasets and Azure Analysis Services (preview)

2.so you could update your Desktop to the latest version and then in Power BI Desktop go to File > Options and settings > Options, and in the Preview features section, select the DirectQuery for Power BI datasets and Analysis Services checkbox to enable this preview feature. Two datasets can be connected in desktop, but the mode is changed from live connection to direct query.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks, that's a good step forward.

However, MS still needs to fix some issues:

1-I still can't upload both usage datasets in the same PB desktop report.

2-The usage datasets only provide data for the last 3 months.

Any company would at least like to see a yearly trend.

3-I can't see the data after uploading the usage dataset. I can only see the visuals I created and the model that joins the tables.

BTW, regarding the above. Yes instead of using the above usage datasets, you can get Log data from the admin, but it is basic login data.

Regards

[lbendlin]

The only thing the tenant audit logs are missing is page level detail. Everything else is there, and then some.

[lbendlin]

Ask your tenant admin to give you access to the audit logs (usually they are put into dataflows). That will make it easier to monitor usage across workspaces/apps.  Note:  does not provide page level granularity.

[Anonymous]

Thanks, but data logs do not provide report USAGE data, just who viewed the report with a date stamp.

So, regarding my question......Power Bi doesn't allow to upload 2 USAGE datasets (from 2 workspaces) into 1 Power Bi desktop report.

And to make things worse, MS only provide report usage data for the last 3 months (so you can't generate a yearly trend). MS and the Power Bi team should review usage datasets to fix these problems.

Regards