cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GerryFlanagan Regular Visitor
Regular Visitor

Refreshing data sourced from a different tenants on prem SQL servers

Hi,

 

Looking for advice on how best to adopt P.BI in the following scenario. I have a P.BI pro account with @companyA and with @companyB. Each account is under a different tenant. If I create a pbix file using companyA's on prem data source's can I publish that pbix file to my companyB account? And if I can, is it possible to enable the data to refresh from the other tenants on prem data sources?

 

Regards,

Gerry

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Refreshing data sourced from a different tenants on prem SQL servers

Hi @GerryFlanagan,

 

This article ( How should I share Power BI dashboards and reports? ) introduces available ways to share dashboard in Power BI currently. You can see only "Share a dashboard" and "Publish to web" provide a way to share with user outside of the organization. Except these way, there is no method to achieve your requirement now.

 

Besides, I found a similar idea item: Publish content pack outside your organization. You can vote and comment on it.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Moderator v-qiuyu-msft
Moderator

Re: Refreshing data sourced from a different tenants on prem SQL servers

Hi @GerryFlanagan,

 

In your scenario, you can pin the report visual to a dashboard then share this dashboard with the user out side of your organization. You can set the schedule refresh for the dataset, the recipients can see updated data in the dashboard. See: Share a dashboard and reports with colleagues and others.

 

Also you can use publish to web feature to share report with the user out side of your organization. You can set schedule refresh for the dataset, it can take approximately 1 hour for refreshed data to be visible in your embedded report or visual. Please note When you use Publish to web, the report or visual you publish can be viewed by anyone on the Internet. If the report contains sensitive data, I wouldn't suggest you use this feature. For more information, please refer to this article: Publish to web from Power BI

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
GerryFlanagan Regular Visitor
Regular Visitor

Re: Refreshing data sourced from a different tenants on prem SQL servers

Hi @v-qiuyu-msft,

 

I was hoping that there was another way, other than embedding in a Website/sharpoint. Like you say, without security control no sensitive data can be used. Is there any way in which crednetials  from a different tenant can be added as a user on a data connection in an enterprise gateway?

 

Regards,

Gerry

Moderator v-qiuyu-msft
Moderator

Re: Refreshing data sourced from a different tenants on prem SQL servers

Hi @GerryFlanagan,

 

This article ( How should I share Power BI dashboards and reports? ) introduces available ways to share dashboard in Power BI currently. You can see only "Share a dashboard" and "Publish to web" provide a way to share with user outside of the organization. Except these way, there is no method to achieve your requirement now.

 

Besides, I found a similar idea item: Publish content pack outside your organization. You can vote and comment on it.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 138 members 2,038 guests
Please welcome our newest community members: