New Idea
0 Kudos

Estamos migrando o SSAS 2014 para o SSAS 2016, a consulta descrita abaixo quando executada no SSAS 2014 através do Power BI é concluída em poucos segundos, porém ao tentar executar a mesma consulta no SSAS 2016 toda a memoria do servidor do Analysis é consumida e a consulta não é concluída, o que esta inviabilizando a atualização do SSAS 2014 para o SSAS 2016.

 

Abrimos o chamado: 117032215494513 na Microsoft e fomos informados que há algumas RFCs (request for comments) que envolvem ambos os times de produtos (SSAS e PBI) e a explicação é a seguinte:

O SQL Server Analysis Services 2014 tinha um comportamento otimista sobre a habilidade para aplicar alguns filtros em construções “multi-level nested” no DAXMD, como neste caso, que são geradas operações aninhadas. Mesmo mais rápido, esse comportamento pode levar a potenciais problemas (alguns casos fora da curva) em que o resultado retornado pode ser incorreto. Esse comportamento foi trabalhado no SQL Server 2016 e como resultado é necessário materializar resultados intermediários dos cálculos, o que pode gerar dataset muito grandes, elevando o consumo de memória e em alguns casos, gerando exceções out-of-memory.

 

A RFC referente a este problema é a 9229662

 

Fomos aconselhados pelo engenheiro Luciano Moreira a tentar obter ajuda para reescrever a consulta para que este problema seja contornado, vocês poderiam nos ajudar?

 

Consulta:

 

EVALUATE

  CALCULATETABLE(

    CALCULATETABLE(

      ROW(

        "Bruto_Fomento", 'Medidas'[Bruto Fomento]

      ),

      KEEPFILTERS(

        GENERATE(

          KEEPFILTERS(

            GENERATE(

              KEEPFILTERS(

                GENERATE(

                  KEEPFILTERS(

                    GENERATE(

                      KEEPFILTERS(

                        GENERATE(

                          KEEPFILTERS(

                            GENERATE(

                              KEEPFILTERS(

                                GENERATE(

                                  KEEPFILTERS(

                                    GENERATE(

                                      KEEPFILTERS(

                                        GENERATE(

                                          KEEPFILTERS(

                                            GENERATE(

                                              KEEPFILTERS(

                                                GENERATE(

                                                  KEEPFILTERS(

                                                    GENERATE(

                                                      KEEPFILTERS(

                                                        GENERATE(

                                                          KEEPFILTERS(

                                                            GENERATE(

                                                              KEEPFILTERS(

                                                                GENERATE(

                                                                  KEEPFILTERS(

                                                                    GENERATE(

                                                                      KEEPFILTERS(

                                                                        GENERATE(

                                                                          KEEPFILTERS(

                                                                            GENERATE(

                                                                              KEEPFILTERS(

                                                                                GENERATE(

                                                                                  KEEPFILTERS(

                                                                                    GENERATE(

                                                                                      KEEPFILTERS(VALUES('Carteira'[Carteira.Key0])),

                                                                                      CALCULATETABLE(VALUES('Cedente'[CNPJ CPF Cedente]))

                                                                                    )

                                                                                  ),

                                                                                  CALCULATETABLE(VALUES('Cedente'[Grupo Economico]))

                                                                                )

                                                                              ),

                                                                              CALCULATETABLE(VALUES('Cedente'[Nome Cedente.Key0]))

                                                                            )

                                                                          ),

                                                                          CALCULATETABLE(VALUES('Cedente'[Status RJ]))

                                                                        )

                                                                      ),

                                                                      CALCULATETABLE(VALUES('Comercial'[Assistente]))

                                                                    )

                                                                  ),

                                                                  CALCULATETABLE(VALUES('Comercial'[Corretor]))

                                                                )

                                                              ),

                                                              CALCULATETABLE(VALUES('Comercial'[Plataforma]))

                                                            )

                                                          ),

                                                          CALCULATETABLE(VALUES('Data'[Data.Key0]))

                                                        )

                                                      ),

                                                      CALCULATETABLE(VALUES('Modalidade'[Modalidade.Key0]))

                                                    )

                                                  ),

                                                  CALCULATETABLE(VALUES('Modalidade'[Produto.UniqueName]))

                                                )

                                              ),

                                              CALCULATETABLE(VALUES('Operação'[Operação.Key0]))

                                            )

                                          ),

                                          CALCULATETABLE(VALUES('Tipo Documento'[Tipo Documento.Key0]))

                                        )

                                      ),

                                      CALCULATETABLE(VALUES('Tipo Operação'[Tipo Operação.Key0]))

                                    )

                                  ),

                                  CALCULATETABLE(VALUES('Veiculo'[Veiculo.Key0]))

                                )

                              ),

                              CALCULATETABLE(VALUES('Veiculo'[Sigla Veiculo.UniqueName]))

                            )

                          ),

                          CALCULATETABLE(VALUES('Conta Grafica'[Codigo Conta Grafica.Key0]))

                        )

                      ),

                      CALCULATETABLE(VALUES('Tipo Documento'[Sigla Tipo Documento]))

                    )

                  ),

                  CALCULATETABLE(VALUES('Operação'[Spot]))

                )

 

0 Kudos

Unable To Open Document

Status: Needs Info
by rehansiddiqui Occasional Visitor on ‎02-20-2017 02:51 AM

I was working on developing a report in Power BI Desktop. The file was working fine. When I am now trying to open the same file, it automatically gets closed after some seconds.

 

Please suggest. Thanks.

 

Regards,

Rehan

Status: Needs Info
0 Kudos

Hi All,

 

I just logged in after June 1st, and noticed that all my workspaces are now gone from the left hand menu.  If I log into an existing powerBI workbook, I can still push to those workspaces but I'm unable to actually view them through powerBI service. Did this change ? I'm on a pro account and only share individual dashboards to other pro users from in that workspace. If I try to create other workspaces - they also do not appear in the left hand menu. Existing dashboards seem to still exist and be accessible - just not in my UI for some reason. 

Status: Accepted
0 Kudos

I use onedrive personal (.xlsm file).  

My data is changed by a macro (Locally). Sent to the cloud onedrive personpbi2.jpgondr.jpgpbi.jpgal (each hour). But is not updated automatically Power BI

Status: Needs Info
0 Kudos

Cash Refresh Getting Failed

Status: Needs Info
by sivabalan New Member ‎05-31-2017 11:47 PM - edited ‎05-31-2017 11:58 PM

Hi Team,

 

We are seeing one warning symbol in the dataset sheduled refresh secion, even though this report using direct query. There is no sheduled refresh as such. but "Scheduled Cash Refresh" which helps to improve the performance getting failed that's the reason in the dataset section warning symbol is present. But the reports always shows the latest data and it's working fine. we are worried about this warning symbol in dateset section and "sechduled cash refresh failure notice" please advice how to resolve this issue or is it sometingh need attention from power bi team to fix this issue. Thanks

 

Please be note that we are using latest gateway version.refresh error.png

Status: Needs Info
0 Kudos

Usage Metrics not working

Status: New
by ag_tiny Frequent Visitor on ‎06-13-2017 12:53 PM

Hi.

 

My usage metrics for Reports works.

But clicking on usage metrics on any of my Dashboads will give me an error:

 

Something went wrong
We're having trouble loading usage metrics right now.
Please try again later or contact support. If you contact support, please provide these details.
Activity IDa0376797-9a8a-a2f7-8274-cc0e742cadf9
TimeWed Jun 14 2017 03:46:34 GMT+0800 (Taipei Standard Time)
Correlation ID6fe3e8eb-0a91-c231-ceb1-459c511e0190
Version13.0.1700.2465
Cluster URIhttps://wabi-us-east2-redirect.analysis.windows.net

0 Kudos

We are using your Power BI Embedded solution in our portal and we got problem with rendering and content loading performance.

Our portal page consists of several embedded powerBi reports inside an iframe. The performance has been very slow just for content loading, normally at 40s which is unacceptable for our users. Our DB queries run fast under 2-3 seconds.

We use memory analysis tool to measure the memory consumption on the IE browser. When the page was loaded and rendered in the browser, the system memory was assigned to the browser to do these tasks. When the page was reloaded, the system memory still is not released and assigned more to get the reloading done until it hung and crashed.

 

We have reviewed and confirm that we are using the same way to implement for Power BI Embedded on our website with 2 following demo site from Microsoft. Please help to review the issue with browser memory and let us know what need to be updated for the Power BI Embedded.

 

The 2 following examples from Microsoft have the same issue about memory leak as we do now.

http://azurewebsiteexperience.azurewebsites.net/dashboard/FleetSummary

https://microsoft.github.io/PowerBI-JavaScript/demo/code-demo/index.html

 

Status: Delivered
0 Kudos

Can't display visuals on service

Status: Needs Info
by jhatton Visitor on ‎06-01-2017 08:20 AM

I have made a report in the desktop application, however, when I publish it the tables in the report get a Can't display the visual error

 

6-1-2017 11-18-47 AM.jpg6-1-2017 11-19-11 AM.jpg

Status: Needs Info
0 Kudos

Hi,

 

I used PowerBI with no problems until appears the advise of Power BI Pro free for just one year from now. I accepted, and now after I refresh the data and try to publish the update, it appears an error that says: "Relying party: Microsoft Office 365 Identity Platform":

 

Error Microsoft Office 365 Identity Platform - copia.PNG

 

I have not problems with PowerBI online, it's just with Desktop version. Nothing as changed in the network of my work, tried with other valid credentials but still with this one, and it's drives me crazy by now.

Thank you,

 

Fabiola.

 

Status: Needs Info
0 Kudos

Clustered Column chart not pulling data

Status: Needs Info
by ClaraGV Visitor on ‎03-01-2017 01:28 AM

Hi, See picture below, I have a clustered column chart pulling data from 3 measures. In some cases, even though there is data to be shown it's not pulled.

 

Image with a) title selected in the left slicer b) at the top you can see the measure used for '2017 Budget dark purple in the chart) c) the chart doeasn't show any 2017 budget but there is 27K budget. See second image with a snit of the data set where it shows this 27K.

 

01.JPG

 

02.JPG

 

For other titles in the slicer the budget 2017 shows ok:

03.JPG

 

Do you know why in some cases 2017 budget it's shown ok and in other cases it doesn't?

 

Thanks!

C.

 

 

Status: Needs Info
0 Kudos

On Premises Gateway Setup - Authentication

Status: Needs Info
by craigharris New Member ‎06-16-2017 05:23 AM - edited ‎06-16-2017 05:24 AM

We are currently experiencing an issue with opening the on premises gateway configurator. When following the guide, we are unable to progress from the initial sign in, despite a message that the installation has been successful. The guide offers these steps:

 

 

onprem.PNG

But when we move from the first sign in step, we get a blank screen which eventually comes back with the CSS-less sign in box. After attempting to enter password and continue, we see the following error:

 

gatewayissue.png

We have opened up the firewall to allow the TCP connections and double checked with the Powershell command:

powershell.png

This issue recurs regardless of sign-in credentials used, and across the 2 separate machines we are using. Our proxy settings are allowing us to connect to every other service under the sun, so I'm not convinced that is the issue. If anyone could offer us a place to resolve, that would be fantastic....

 

 

 

 

 

 

 

 

 

 

Status: Needs Info
0 Kudos

I have built a PowerBi dashboard which is getting data from Kusto queries.

I have scheduled a daily refresh of the dashboard which is failing because the Kusto connection is timing out during the refresh. Initally i had a single report which had multiple queries. Since the connection was timing out during the refresh i spilt the queries in three seperate reports but still connection is failing during refresh. Please let me know what i can do to ensure smooth refresh of my Kusto queries in powerbi.

Below is the snapshot of the error

 

error1.png

Status: Delivered
0 Kudos

Can't renew Pro Trial account

Status: Delivered
by mwaltercpa Frequent Visitor on ‎05-25-2017 07:47 PM

i have shared all my dashboards through a group.  my internal users w pro trial accounts are telling me that it is asking them to purchase pro to view the dashboard.  then it takes them to a subcription page to choose a plan.  there is an option to try pro for free, and it routes then back to the account... however the pro does not renew and they are still being asked to upgrade.

 

is the viewing pro from a group a pay only feature now?

Status: Delivered
0 Kudos

Hi,

Is there a way in which we can share dashboards across different domains accessible on web browser as well as powerbi app. Please find the Scenario below.
E.g.Currently we have a domain user registered to powerbi i.e. test@abc.com (domain being @abc.com).This user shares a dashboard with another user of a different domain i.e. testinguser@xyz.com(domain being @xyz.com)

In such a scenario, an internet link gets sent as an email to testinguser@xyz.com. When testinguser@xyz.com clicks on the internet link, then that link opens in the web browser showing a view only dashboard.This is accessible on the web browser but not in the powerbi app.
We would like a workaround solution for cross domain dashboard sharing with accessibility across web browser as well as mobile app along with notifications as well as enabling subscription.

Status: Delivered
0 Kudos

data refrsh issue

Status: New
by aka Regular Visitor yesterday

Hi guys,

Am a Pro user and i have schedule refresh on few reports on poer Bi services Online, My schedule refresh always shows that is has succedded but when i croass check my data its seems it hasnt load all the data correctly.

Then i force refesh my dataset and then my data accuratley matches.

Can any one guide me through this problem why is this happening.Help will be really appreciated.

 

Thanks

 

0 Kudos

Unable to load model

Status: Delivered
by thamasuna Occasional Visitor on ‎05-29-2017 04:08 PM

I have couple of datasets/reports/dashbaords all published from Desktop for my experiment purpose. Data source is all local file.

 

Until couple of month back, they were all working fine if I remember but now, whenever I try to see reports/datasets, it throws me an error saying 'Something went wrong - unable to load model'. It even doesn't let me remove/rename files. I talked to my admin and seems all other users have same issues.

 

Also oddly, even if they made me admin, once I could see 'Amin Panel' in the gear menu but after 10 mins or so it disappeared and never been there anymore.

 

I have another account under the different domain and it works fine.

 

Anyway to make it work again?

Status: Delivered
0 Kudos

I have a large data model in Power BI pulling from 3 web sources, a SharePoint list and an ODBC source which is where the majority of my data is stored. I wanted to use the Data Gateway for only the ODBC connection. The Data Gateway is setup correctly and is able to pull data from the ODBC souce if I only have the ODBC source in the data model. But as soon as I add a SharePoint list to the file sources, the Data Gateway is greyed out and is no longer working for the report.  

 

I tried to create a SharePoint connection on the Data Gateway but it doesn't have the option to use the OAuth2 authentication method and after some research I found that the SharePoint connector in the Data Gateway is for On-Premise SharePoint not O365 which ours is.  

 

I believe this is a program issue and should be fixed.  If a dataset in the model matches the name of the source in the Data Gateway, then it should use the Data Gateway.  If it doesn't match then it should connect directly to the data source without using the Data Gateway.

Status: Delivered
0 Kudos

Hi,

 

My map gets populated when I work on PowerBI desktop version, but it doesn't when I embed it online on dashboard.

 

Surprising, all was good, map was working in online version couple of weeks ago (Chrome, IE 11)

 

 no.PNGyes.PNG

Status: Delivered
0 Kudos

Power BI SharePoint Embedded was released but the caption on Power BI Service Still in Preview.

 

preview SharePoint.PNG

0 Kudos

In my table a blue/green line is shown.

I have just downloaded the newest Power BI desktop today.

 

Here it is shown in desktop - grey line in the bottum:

 

Capture2.PNG

 

¨Here it is shown in the service, with a green/blue line:

 

Capture.PNG

Idea Statuses