Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Direct Query SAP HANA Credential Lockout

Hey all,   General inquiry and may need some guidance here for best practice. When performing a Direct Query to a SAP HANA data source, I connect to the data source of interest (server/custom port)...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI Anonymous,

    For 'direct query' mode data source, you need to keep its data credentials valid. (notice: it refreshed triggered every time users interact with visuals or table records)

    So if you change your credentials on Datasource side, you also need to update your data source credentials on power bi service dataset side.
    For local report file changes that apply to power bi desktop, it does not interact with published power bi service contents.

    Regards,

    Xiaoxin Sheng

Terrance's avatar
Terrance
New Member
6 years ago

Under Data Source Type, select SAP HANA.

 

Add the SAP HANA data source

 

After you select the SAP HANA data source type, fill in the Server, Username, and Password information for the data source.

 

All queries to the data source will run using these credentials. To learn more about how credentials are stored, see Store encrypted credentials in the cloud.

 

After you fill in everything, select Add. You can now use this data source for scheduled refresh or DirectQuery against an SAP HANA server that is on-premises. You see Connection Successful if it succeeded.

 

Advanced settings

Optionally, you can configure the privacy level for your data source. This setting controls how data can be combined. It's only used for scheduled refresh. The privacy-level setting doesn't apply to DirectQuery. To learn more about privacy levels for your data source, see Privacy levels (Power Query).