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
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Nick2358 ,

 

Do you mean to connect a Power BI Service dataset and a local excel file at the same time? 

If so, I think the connection mode of this dataset will become DirectQuery.

Please provide me with some screenshots about your issue.

 

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 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