Change SAP HANA Datasource when using Direct Query as a multi-dimensional source possible?

Question

Hi all&nbsp;We are facing a problem where the database packages in SAP HANA are changed to ensure consitent modelling.We will need to migrate the views to those new locations, but are having problems with changing&nbsp; the power BI reports.&nbsp;As by default, Power BI recommends to use Direct Query as a Multi-dimensional source. We already created reports and measures in those reports so we would like to just change the source "Location/path".I know that in a relational context with Direct Query, you can change the source (path) within the Query Editor.&nbsp;&nbsp;Is there a way to do the same in an Multi-Dimensional Context, without braking the report?&nbsp;&nbsp;Kind RegardsJasper Baert

amitchandak · Answer

JasperBaert , refer if these can help
https://www.youtube.com/watch?v=y3se-VEDvqUhttps://www.youtube.com/watch?v=ncNmrPamRSghttps://answers.sap.com/questions/675539/integrate-sap-ecc-to-power-bi.htmlhttps://www.element61.be/en/resource/microsoft-power-bi-top-sap-data-sources-winning-combo

jasperbaert · Answer

Hi AmitchandakThese are really general overviews of the possibilities with HANA &amp; Power BI Direct Query.The above question is specifically on changing the HANA Source, which is an exact copy of the previous source. Same data, same measures, same descriptions.&nbsp;Normally you would change this in Query Editor, but since it is greyed out for multi-dim sources, we are really stuck on how-to change this.&nbsp;Thanks for the proposals, but still searching for a solution!

anonymous · Answer

Hi&nbsp;JasperBaert&nbsp;,Please check if the following blogs can help you:How to change data source in Power BIHow To Change Data Source Of Existing Report In Power BIBest RegardsRena

jasperbaert · Answer

Hi&nbsp;AnonymousYes, this works for let's say DEV, QA en PRD&nbsp; systems, but you can't change the "Source Path".We want to change the structure of our DB, and therefore change the path to that one source or view.&nbsp;Kind RegardsJasper Baert&nbsp;

anonymous · Answer

Hi all,&nbsp;Has this request been solved.We are in the same situation where we also would like to change the Hana view for a PowerBI report, or more specific, copy a PowerBI report and change the source of the new report to a different (but simular) HANA view.- And yes we are also able to change the datasource to source from either the Q- or P system, but that is not what we are looking for.&nbsp;&nbsp;Regards Anna Gabs

Forum Discussion

Change SAP HANA Datasource when using Direct Query as a multi-dimensional source possible?

5 Replies

Related content

Multi-Dimensional Json file to Table

Possible Localization issue

DataSource not found

semantic model - get datasources

Datasource for Power BI