Forum Discussion

PowerBSer's avatar
PowerBSer
Frequent Visitor
8 years ago
Solved

Transition to Power BI Service Datasets / Power Query greyed-out

Hello,   I am seeking help transitioning to Power BI Service data sources.   Origional approach: Local data sources (excel sheets), manual refreshing of reports via PBI Desktop Editor.   New a...
Need Help
  • PowerBSer's avatar
    PowerBSer
    8 years ago

    Thank you for your response.

     

    However, I believe Edit Queries is disabled once you configure a Power BI Service data source, including documents hosted on sharepoint.

     

    I am now thinking that I will have to go with a proper sql server to accomplish what I need.  Luckily, I found the right contact for support within the organization.

     

    Thank you Cherry,

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi PowerBSer,

 

Firstly, if you get data with Power BI Service dataset in Power BI Desktop, there is a live connection so you cannot use Eidt Queries.

 

In addition, you could try with connect the excel worksheet in SharePoint online directly in Power BI Desktop.

 

 

Then you could use Edit Queries.

 

Best Regards,

Cherry

  • PowerBSer's avatar
    PowerBSer
    Frequent Visitor
    8 years ago

    Thank you for your response.

     

    However, I believe Edit Queries is disabled once you configure a Power BI Service data source, including documents hosted on sharepoint.

     

    I am now thinking that I will have to go with a proper sql server to accomplish what I need.  Luckily, I found the right contact for support within the organization.

     

    Thank you Cherry,

    • v-piga-msft's avatar
      v-piga-msft
      Resident Rockstar
      8 years ago

      Hi PowerBSer,

       

      Yes, you're right. Once we connect with the Power BI Service datasets, the Edit Queries will be disabled, becase we cannot use Edit Queries under live connection.

       

       

      It's glad that you have found a solution. Please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

       

      Best Regards,

      Cherry