Forum Discussion

Nick2358's avatar
Nick2358
Helper III
5 years ago
Solved

Importing dataset locks menu options

Hello everyone,   Here is my problem today. We gave access to several datasets to people within my company so they can do what they want with their data without messing with any of the data sources...
Need Help
Nick2358's avatar
Nick2358
Helper III
5 years ago

Hi Anonymous please find some screenshots attached.

 

This is after I import my dataset then most of the usual features I use are locked. 

 

Also, following you comment, when I want to import a dataset it only says "Create" but I can't choose between "import" and "direct query" like I usually do.

 

Thanks for your help,

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Nick2358 ,

 

Well, the connection modes of Power BI Service datasets on Power BI Desktop is live connection. If you add other data sources when there is already a dataset, the connection mode of the dataset will become DirectQuery.

I think it is because the connection mode is live connection. Live connection is to import a completed data model into Power BI, so some functions of the menu bar will be restricted.

 

Reference: DirectQuery, Live Connection or Import Data? Tough Decision!

                  Connect to datasets in the Power BI service from Power BI Desktop

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

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Nick2358's avatar
    Nick2358
    Helper III
    5 years ago

    Hi Anonymous 

     

    Thank you for your answer,

     

    Based on what you said I ended up exporting the dataset from the Service instead of importing it in a blank pbi file. 

     

    And from there I can access all my usual features,

     

    Thanks,

     

    Nick