Forum Discussion

Dali748's avatar
Dali748
Helper II
7 years ago

Edit Queries grayed out - How can I view the source data in Excel and append data to this source?

I still have access to an intern's account who no longer works here.  He created a report in "Service" under his "personal workspace" so there isn't an option to download the *.pbix file.  So I ended...
Need Help
Dali748's avatar
Dali748
Helper II
7 years ago

Anonymous  Thank you for the reply!

 

I'm logged in both Power BI "Service" and "Desktop" with the intern's account; so I should have full access to the dataset since he's the one that created it.

 

In "Desktop" I just selected the dataset and then recreated the report view, but I can't seem to find a way to actually see the dataset in "Edit Queries" because it's grayed out and I'm sure I have full access since I'm logged in as the intern who created it.

 

Could it be because he initially created this dataset from "Service" and not "Desktop"?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Dali748 ,

 

I meant from where is your data coming. Which source? you will have to check with that.

 

I had similar problem with limited access and my source was SAP HANA database. I requested to give me an access to the database and this resolved my problem.

 

May be this helps you!

 

Thanks,

Tejaswi

  • Dali748's avatar
    Dali748
    Helper II
    7 years ago

    Anonymous My data source seems to come from an Excel file

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Dali748 ,

       

      Did you also try this option of downloading the .pbix file? click on three dots .

       

       

      Or else you would have to open a new desktop file and use that excel as a source for your reports.

       

      Thanks,

      Tejaswi