Solved: Data from PowerQuery missing in PowerBi model

ThomasPyndt · ‎03-04-2020

Hi

I have a strange problem: I have a table of countries, which I gathered using PowerQuery from CDS:

(Pay attension to the Continent and Country/Region columns)

Now, when I load this table into PowerBi, the Continent and Country/Region columns are blank:

I have tried deleting the table and readding, but without success.

Any ideas?

mwegener · ‎03-05-2020

Take a look at this.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials

mwegener · ‎03-05-2020

Take a look at this.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials

ThomasPyndt · ‎03-10-2020

Thanks a lot mwegener - worked like a charm 🙂

mwegener · ‎03-05-2020

did you remove the associated GUID from the query?

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials

Data from PowerQuery missing in PowerBi model