Forum Discussion
Kergofil
5 years agoRegular Visitor
If statements - limitations
Hi . I have a list in excel of more than 1200 post codes and the area they belong to (2 columns in the excel, one is the post code and the other is the area). I am using direct query in power bi and...
Kergofil
5 years agoRegular Visitor
Hi
As you state, I am loading more data and one of the columns I download is the Postcode. Direct Quey unfortunately is necessary in my case.
Yes indeed there is a gateway installed and therefore I can easily share my report in Power BI service.
PhilipTreacy
5 years agoSuper User
Hi Kergofil
OK so given all of that, then just do the table join ?
Or add a new column to the SQL data for the Area Code so the join doesn't have to happen?
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.