Hey there
I'm having the following problem:
In power query I have table A and table B. I have joined table A and B to create table AxB (full outer join).
Data loads perfectly, everything works fine, visuals are working and the report is ready to publish.
Then, I publish the report to a workspace belonging to my username, the workspace is not on dedicated capacity since I own a pro license.
As published, the report and the data works fine, then, I go to the dataset settings and configure the gateway to refresh all the data.
Data refresh is successfull, and all data is updated correctly, latest changes to both table A and B are being brough.
The problem is that after refresh, table AxB is empty.
I would also like to mention that there are less than 100000 rows, I even limited the data to less tan 10000 rows to see if it would fix the problem and it didn't.
--
What I tried:
I published again and reconfigured the report entirely, it didn't fix the problem. I also tried joining the tables again, it works on the desktop app but the published dataset stays empty.
I downloaded the report (complete with dataset) from the published version and refresh it on the power bi desktop app, the AxB table becomes populated. This means that there is no error with the data and that the real problem is that the join operation is not being performed on the published dataset.
Does anyone know why this might be happening?
