The SAP BW Connector currently does not support Live or Direct Query. Some customers are looking for this feature.
14 Comments
- nishalitNew MemberThanks for the feedback - SAP BW DirectQuery mode was added in the Power BI Desktop June 2017 release and in the On-premises data gateway July 2017 release.
- SatyaVaitla
Advocate II
if I select only very few measures and dimensions for test purpose, the results are excellent in power BI desktop. As SAP collects excellent data about attributes, the data lends itself for lot of analysis scope to throw outliers and trends. But SAP is not for small data or for small hearts! Also the preview version is not detecting measures and dimensions. We need to tell it explicitly after import. However, during import selection, it is displaying measures and dimensions with symbols for selection as SAP BW fields. - SatyaVaitla
Advocate II
As the preview release of SAP BW connector is not supporting direct query, practically it is becoming useless as the data with SAP back ground is always huge. For any of my requirements, data is not loaded into power bi desktop and says the internal table can not be extended. So running of queries on ware house server is essential for SAP data - balaji_rajaman1New MemberThis is key for users to reuse work done in BEx queries along with data mash capabilities of Power BI
- rajudakojuNew MemberThis feature is a must, if not the integration with SAP BW is not useful. We should be able to change the parameters and refresh for various options available.
- PraiosNew MemberI fully agree, import Data in Power BI if we have already EDW on BW doesn't make sense because we replicate data and it's not the philosophy of standard BI. Import data can be usesd for prototyping or merging data from different data sources.
- CAINew MemberLiveQuery for SAP BW would be a huge step foreward.
- chotanasRegular VisitorAnyone know if I can see queries create in BW in Porwer BI , I have the connection in Power BI - BW but I can not see the Queries yet (just the cubes)..........( in the propierties of the Query , in Extended/Advanced tab, I checked to let Allow access to external OLEDB and I can not see it yet )
- babiarz_konradNew MemberCannot wait for IT. It will be a massive step to become a leader in data visualization! Adding to this SSO will open a huge market in front of Power BI and easy implementation. Adding this in on-premises mode will smash the competition!
- lfieldsNew MemberAny updates?
Recent ideas
New Advanced Editor hides query name and locks editor window
Classic Power Query 'Advanced editor' opens as a separate movable, resizable window with the query name as its title. One could drag and keep the main editor visible : queries pane, applied steps, d...Mardurolla1 hour agoRegular VisitorNew6Views0likes0CommentsGet Secret from Azure Key Vault using Fabric Workspace Identity
Users can access key vault secrets using notebookutils.credentials.getSecret. This is based purely on the user's access (or object owner's access, if the notebook is being run in a pipeline). In larg...sean_cochran1 hour agoResolver INew3.1KViews14likes3CommentsNew Power Query experience: Advanced Editor modal hides query name, and locks the editor
In the classic Power Query editor, the Advanced Editor opens as a separate, movable, resizable window titled “Advanced Editor – QueryName”. I routinely drag it to a second monitor and keep the main e...lamogiro2 hours agoNew MemberNew4Views0likes0CommentsPaginated Reports with PowerQuery - Cloud connections for Snowflake connector
Current situation: Power BI report builder used to build a report using Power Query dataset. Report builder picked the right cloud snowflake DB connection (created in Power BI service portal - app...jarjis_nbcu2 hours agoNew MemberNew1View0likes0CommentsNew Power Query experience: Advanced Editor modal hides query name, and locks the editor
In the classic Power Query editor, the Advanced Editor opens as a separate, movable, resizable window titled “Advanced Editor – QueryName”. I routinely drag it to a second monitor and keep the main e...Mardurolla2 hours agoRegular VisitorNew8Views0likes0Comments