Default Summarization Not Working

Hi Anonymous ,

First of all, thank for your reply. 

I'm using the 2.87.762.0 64-bit (November 2020) PBI version.

In this report, I've a very similiar table, called 'f g_ads'. Basically, I've the same structure for 'f fb_ads' and for 'f g_ads'.  

In order to provide as much information as possible, I'll include in this reply some screenshots from both of this table, as well as the relasioship of both of than with the 'd calendar'.

• 'f fb_ads'  Table Structure

• 'f g_ads' Table Structure

•  Relationship of Tables

I tried to use the default summary for other numeric fields, but even if these fields are set up as integers or decimals, it appears that PBI is treating it as strings, because everyone is exhibiting the same behavior.

All my date come from MYSQL database, and for some tables, when importing, I need to use some SQL JOINs to import only the data that it matters. 

i.e. 

SELECT d.* FROM `g_ads_anuncio_dias` d #(lf)INNER JOIN g_ads_anuncios a ON d.anuncio_id = a.id#(lf)INNER JOIN g_ads_grupos g ON a.grupo_id = g.id#(lf)INNER JOIN g_ads_campanhas c ON g.campanha_id = c.id#(lf)WHERE c.conta_id = 3"

And, by doing this, the navigation step causes an error, and in orther to keep importing data, I remove this step from the APPLIED STEPS section on Power Query Editor.

But even the tables that don't need to be JOIN are presenting the same problem

. 

I do not know what else could be causing this issue.

Best Regards,