cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
efeiles Frequent Visitor
Frequent Visitor

Can you connect Power BI Service to existing dashboards on a Power BI Report Server?

We are trying to start using Power BI Service to send out email subscriptions to dashboards.  I am having an issue refreshing data in PBI Service when using import queries.  I figure it is because once you published the file it can't refresh from that file again (not sure).

 

We have an On Prem Power BI Report Server that we have been using to publish dashboard for the company, but it has recently been brought up to have the ability to sent email subscriptions of dashboards.  

 

We have an on prem gateway to connect to data in our SQL Server, but the refresh options do not seem to work unless using a direct query.

 

I was thinking maybe there was a way to connect to dashboards published on the report server and being refreshed there.

 

Any insight is welcome.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Michiel Member
Member

Re: Can you connect Power BI Service to existing dashboards on a Power BI Report Server?

You should be able to refresh a dataset with data imported from SQL Server just fine through the data gateway. But the gateway administrator should enable access for you. This can be managed on a quite detailed level, so it may be that the queries you want to use are blocked, while direct query still works.

View solution in original post

efeiles Frequent Visitor
Frequent Visitor

Re: Can you connect Power BI Service to existing dashboards on a Power BI Report Server?

I got with my administrator and was able to get it refreshed properly.  Thank you for the direction.

View solution in original post

2 REPLIES 2
Michiel Member
Member

Re: Can you connect Power BI Service to existing dashboards on a Power BI Report Server?

You should be able to refresh a dataset with data imported from SQL Server just fine through the data gateway. But the gateway administrator should enable access for you. This can be managed on a quite detailed level, so it may be that the queries you want to use are blocked, while direct query still works.

View solution in original post

efeiles Frequent Visitor
Frequent Visitor

Re: Can you connect Power BI Service to existing dashboards on a Power BI Report Server?

I got with my administrator and was able to get it refreshed properly.  Thank you for the direction.

View solution in original post

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)