Forum Discussion

globalmc's avatar
globalmc
Helper I
4 years ago

Shared dataset Import mode

If I have a workspace (premium ) on western region , and have a report and dataset , 

the dataset is shared , 

and I have another workspace (premium) on asia reigon , and this workspace , build a report connect to the shared dataset. 

 

In this case, can use import mode and daily refresh ? If possible how to do that ?

Data Protection
Need Help
Show and Tell
Tips and Tricks

6 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    4 years ago

    Hi globalmc 

     

    When you connect to a dataset all the data still is in the actual dataset.

     

    So based on your question if you want to use import mode, you would need to import the data into a new PBIX and then publish this to your asia region.

    • globalmc's avatar
      globalmc
      Helper I
      4 years ago

      thanks. and can you show me how to do that ? Something like the following ?

       

      1. Open power BI desktop 

      2. Get Data and choose the shared dataset 

      3. Build the report and publish 

       

      Is it something like in the above?

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    Hi globalmc ,

     

    As far as I know, when you connect to a shared dataset using Desktop, a live connection to the dataset is created. You can change the connection mode to DirectQuery, see the documentation for details.

    Create reports based on datasets from different workspaces 

    Using DirectQuery for Power BI datasets and Azure Analysis Services (preview) 

     

    But the shared dataset is not supported in import mode. After creating a report to upload to the Service, you can configure the credentials and set up scheduled refreshes.

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.