Forum Discussion
If statements - limitations
Hi Kergofil
Just so I understand this correctly, you have SQL Server running on your PC in Direct Query mode and you are only loading 1 column from it that contains the post code? Or you are laoding a lot more data/columns than that, but 1 of those columns is the post code?
Is Direct Query necessary? You state that you need your data to be live in which case you either need to leave your PC on all the time or you move the SQL DB and Excel file to the cloud/some other always on location.
Also, if your data is stored on your PC, you may need to set up a gateway to allow reports to be shared on PBI Service.
Seems like there are 2 issues here: live access to the data because of Direct Query, and then the need to join the tables.
Regards
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.
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.
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.