Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Issue with updating credentials in dataset

Hi,   I am having issues with updating credentials in dataset after uplading report to Power BI online.   My report is using data from excel file via sharepoint.   I have changed credentials in...
  • Anonymous's avatar
    Anonymous
    7 years ago

    Solved it!

     

    I have moved excel file into workspace OneDrive, so no gateway needed.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi,

 

It looks like I don't have any of these.

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous，

In your scenario, do you take merge/append operations using table of SAP hana and table of Excel files in Power BI Desktop? If so, you would need to use personal model gateway to refresh your dataset.

However, if there is no merge/append operations, you can use on-premises gateway to refresh your dataset, and you would need to add SAP hana data source within the gateway.

Regards,
Lydia