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,

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
Icon for Resident Rockstar rankResident 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