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 (easy things like creating tables, charts, etc.).

 

My problem is some of them want to access the "Data" view or import some of their own Excel spreadsheets to create a relationship witht the dataset, etc. but from the moment they import a dataset most of the usual options from the menu get locked.

 

Does anyone know if there is a way to get past this so they can use the options?

 

Thanks in advance for your help,

 

Nick

Need Help

6 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Nick2358 , If I got it correctly. You are importing a power bi dataset.  After dec -2020 there are some limitations are removed. I am able add a dataset with an additional local table, but not able to join that with a data model coming from a dataset with a new table. I am on April 2021.

     

    I first added local file, then added power bi dataset

     

    • Nick2358's avatar
      Nick2358
      Helper III
      5 years ago

      Hi amitchandak,

       

      I'm on April 2021 too and that's what I thought would be the best solution. It's just not great when you have to make potential adjustments after importing the dataset...

       

      And do you know if there is any solution to having the "Data" view or adding columns, etc. after importing the dataset?

       

      Thanks,

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