Hierarchy from SAP BW via Import mode to PowerBI
Hi everybody We use SAP BW as the backend. There I have characteristics with several hierarchies and these hierarchies have several levels, e.g. G/L account hierarchy (by G/L account, by DB level, by result, etc.) or cost center hierarchies or profit center hierarchies or product hierarchies (by product, by sales, etc.) Can these hierarchies - i.e. on the one hand the hierarchy with several levels per characteristic and on the other hand - if a characteristic has several hierarchies (with several levels) - these can be loaded into PowerBi? I was told that no hierarchies or max. 1 LEvel can be loaded with the import mode, as hierarchies can only be loaded completely with the DirectQuery mode. Is this correct? Unfortunately, I am currently receiving an error message in import mode. GreetingsPowerBI connection issue. The received certificate has expired
Hi, I am receiving the below error while trying to access SQL server (get data--> SQL server database). Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The received certificate has expired.) Also, when I check the logs I get the below error info: "Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.MashupDataAccessValueException: Mashup expression evaluation error" . The gateway was working fine before and now I get this error. I checked the certificate issued to the server and looks fine. I would appreciate if someone could advise what could be missing or the correct spot where I can check to resolve this issue.
How to Sync Powerbi ML regrestion output data to actual report data
Hi Team, Kindly assist in synchronizing my regression ML output model data with the live dataset for time series forecasting. Please refer to the attached screen shot for your convenience. Thank you. also let me know any other way to import that model / how to read. Sample output
How to connecting PBIRS to PBI APP
Nós nos conectamos ao DataLake no PBIRS e publicamos o conjunto de dados do aplicativo Power BI. Criamos outro arquivo PBIRS, conectamos ao conjunto de dados que carregamos no PowerBi App e depois publicamos no Sinfonia. Com isso, a opção de acessar uma fonte de dados ficou disponível. No entanto, nos deparamos com uma nova barreira, pois estamos familiarizados em fazer essa conexão com algum usuário do serviço conectado ao banco usando a opção básica autenticada. Mas como neste caso estamos conectando o PBIRS ao PBI APP, esses usuários não funcionam. Tentamos nossos próprios usuários como dominio.com.br usando os dois tipos de login, mas não tivemos sucesso. Como fazer essa autenticação?
