Forum Discussion

DJJR10's avatar
DJJR10
New Member
2 years ago
Solved

Data Sync Challenge between Internal and External Power BI Reports

I'm working with data from SQL Server, using a Power BI gateway to access it within our organization's premium workspace. We're expanding to provide reports to external clients from another premium w...
Dataflow
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi DJJR10 ,

    Please try below steps:

    1. create two report in Power BI Desktop and publish it to the service different workspace with the same data source with import connection type

    2. install and configure On-premises gateway in the local machine that could access the data source successfully

    3. create data source for the gateway in Power BI Service Portal, configure the dataset settings for the two dataset and set the schedule refresh policy

    4. the dataset could refresh the dataset according to your policy

     

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi DJJR10 ,

Please try below steps:

1. create two report in Power BI Desktop and publish it to the service different workspace with the same data source with import connection type

2. install and configure On-premises gateway in the local machine that could access the data source successfully

3. create data source for the gateway in Power BI Service Portal, configure the dataset settings for the two dataset and set the schedule refresh policy

4. the dataset could refresh the dataset according to your policy

 

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