Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Lexi_Liu
Frequent Visitor

Publish custom usage metric report into Workspace: no gateway to access the data source file

Hello!

I created a custom usage metrics report because I would like to track utilization% between my target audience, but not all users although they have access to those reports.

I have 1 excel file contains my target audience email list saved in Sharepoint, and 2 Power BI datasets for 2 usage metrics report from 2 Workspace which I have admin access. It works well in my desktop and can be refreshed when I open it.

However, if I publish into Workspace, either my Workspace or other Workspace I have access to. It shows error says "There is no gateway to access the data source File. In Datasets setting page, it says "This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed. Learn more: https://aka.ms/dynamic-data-sources. Data source for Query1"

When I open the report I found the issue is from the 2 Power BI datasets, because data from the excel file are showing up correctly, but others are showing "can't display the visual: Couldn't load the data for this visual".

Is there a way to solve this issue? or if there is a better way to create and publish a custom usage metrics report with custom measures & data source?

Thank you!

 

1 ACCEPTED SOLUTION

Yeah, you can't combine other sources with a PBI dataset. You can add measures etc though. If you want to truly customize, you can get the usage data out of the PBI Admin API and put it in a database with an ETL tool - it's handy to have that data anyway, it just takes considerable effort to get. 🙂

View solution in original post

4 REPLIES 4
christinepayton
Super User
Super User

You can't schedule refresh on PBI datasets because they are live - they don't need refresh. If I recall, though, the auto-generated usage reports in the service are something that you can edit (at one point I downloaded one of them to look at the DAX queries that were used out of curiousity), have you tried that? 

Thanks Christine! I tried to edit in the service but no option for me to add my own data source (the target user list) in the metric report, so I created a new report in desktop, but then the data cannot display if I publish into Workspace.

Yeah, you can't combine other sources with a PBI dataset. You can add measures etc though. If you want to truly customize, you can get the usage data out of the PBI Admin API and put it in a database with an ETL tool - it's handy to have that data anyway, it just takes considerable effort to get. 🙂

Thank you! Now I understand 😃

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors