Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

modi123p

DataSource.Error on loading date hierarchy in SAP BW Query

Submitted by Helper III on ‎12-05-2016 11:13 PM
Hi,
I m new to SAP BW as well as Power BI. When I try to include Date hierarchy, power BI seems to fail with the error message "DataSource.Error: SAP Business WareHouse: You may not use more than one hierarchy per dimension". BW Query seems to be fine. Request your help in resolving this issue ASAP.
Please suggest solutions or work a rounds for the same. I have October update of power bi.
Status: New
See more ideas labeled with:
2 Comments (2 New)
Comments
sinideepu
New Member
‎03-09-2017 07:56 AM

did you find an answer

modi123p
Helper III
Helper III
‎07-05-2017 07:36 PM
Date dimension listed more than one element n the hierarchy and all were getting selected. The structure of dimension was modified on SAP BW and I m able to select only one element in the hierarchy. Problem solved.
Idea Statuses