Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Get Data is greyed out

I haev a dashboard with 2 data sources on Sharepoint Folders. refreshes OK . I do not see the Data and Datamodel tabs on the left side. When I want to add a third data source, Get Data is greyed out....
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I have replied three times to this thread, each time the message is not recorded.

 

The issue is that PBI desktop considers connectsion to PBIU Service datasets to be LIVE connections,m whereas the PBI datasets are not LIVE, they are excel sheets in Sharepoint folders on an ourly update. that is not LIVE.

 

I do not have a work-around. 

 

It is a severe limitation of the toolset, that it cannot recognize the correct configuration of data sources.

mattneil's avatar
mattneil
Frequent Visitor
6 years ago

Hi Anonymous 

 

As mentioned above it sounds like the Report you're working on was created using a Live connection to an existing Power BI dataset.

 

To add another data source, you'll have to get the .pbix file for the original report dataset and edit/republish there.

 

In the Workspace go to Datasets, then download the .pbix file from the relevant one.

 

Cheers,

Matt