Forum Discussion

IanR's avatar
IanR
Icon for Helper III rankHelper III
8 years ago
Solved

Data loads in Power Query but not in Power BI

I have a query that loads sample data in to Power Query but does not load any data into Power BI. I used the advanced editor to grab the M code for the query and used it to recreate the query in anot...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    IanR Yeah, the column names or values in yellow are what I'm referring to. If you can expand and dig in as you describe that is the functionality that will slow things down exponentially. I can't speak to the "why" or "where" in the processing, all I know is it kills the processing in Power BI.

    There should be relationships that you can use in these entities to build relationships within Power BI. For all of the translations from ID to name or description, those you will most likely have to re-create in Power BI. You can build those columns of values within the table, or add them as seperate dimensions if the lists are huge and relate them via the ID.

    Another tool I've used to see the actual names vs. what CRM (Dynamics 365) shows is the XRM Toolbox. You can download the schema and it is extremely helpful as it shows you all the value transformations for dropdowns, etc.

    I've used the above methods, only pulling data, and everytime the data loads in under 5 minutes.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

IanR,

I am trying to reproduce your issue, however, when I use "Append Queies as New " to append two tables, even if I untick "Enable load" option for one stage table, after I click "Close & Apply" in Query Editor, I can see complete data in the appended query in Data View. Moreover, after I tick "Enable load" option for the stage table and click "Close & Apply", the data appear in stage table in Data View.

In your scenario, do you make sure that the missing data of final table come from the staging table? And after you tick "Enable load" opion for the staging table and click "Close& Apply" , please right-click the "Refresh" button under Home ribbon to re-process data model as other's post, then verify if data appear in the staging table in Data View.

Regards,
Lydia